SSIS

1K

Solutions

21

Articles & Videos

958

Contributors

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.

Refine results

Hi!

I have an SSIS 2012 package that loops through files using a for each loop and loads data into a table.

However, I'd need to handle a couple a scenarios that I'd need to take care of in the …

612 views
Courses: Start Training Online With Pros, Today
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Are ssis dynamic queries reliable?

211 views

Hi!

I have an Ssis package say abc.dtsx,that loops through files and performs a few validations using Ssis tasks such as Execute SQL task,etc.
After the for each loop is executed, I have an …

530 views

I have read-only access to a database (eg DB1) via MS SQL Server Management Studio (SSMS). I created an SSIS package in Visual Studio that exports all the tables in the database, DB1, to Excel. Now, …

636 views

Hi, I am exporting some data to excel using SSIS.

I have a datetime field in my sql server 2008 DB showing as '2009-05-27 16:09:00.000'

but after the data is exported to Excel using SSIS the …

311 views

Greetings.

I am a total C# neophyte. The last time I code in C was in 1995 and that was just for a computer class. I can read code a little but need help in deciphering just what this block of code…

528 views

how to upgrade SSIS from SQL 2008 to SQL 2014/2016.

From my experience for all SQL server upgrade project I done myself which has no problem, SSIS package always no problem, but when SQL server …

2647 views

What data flow task would i use in SSIS to return the results of a function? I will need to pass in a varchar value which will return a  varchar value

520 views

I have a field Accept_Referral

IF the value is 'yes' in want the derived column to return 1
if no the derived column should be 0
if null then just leave it as null

How?

728 views

I need to build a SSIS that
Connects a VPN
Then establishes a .net SQL Server connection string through the vpn connection.

273 views
Gigs: Get Your Project Delivered by an Expert
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

I have a job on my SQL 2005 server that I want to view/Modify in SSIS but cannot find the package that is in the Job I have looked everywhere on the server and cannot find the package a want to …

1642 views

Hi,
I need to be able to redirect rows in SSIS when the source column is an empty string. I have set up a conditional split that redirects rows that are null in the source. Any help would be …

119 views

Hi,

Is there any way to convert exponential value to number in sql server . For e.g.

Input
1.22222222222222E+52
Output
12222222222222201000000000000000000000000000000000000

539 views

I have a Conditional Split in my SSIS job that hits on 10 different conditions.  It sends the default output to Table A.

I'd like to send every OTHER conditions to Table B.  How do you send …

731 views

Hello EE experts,
I have a folder and I need to get the most old file from a folder in the SSIS package.
Is it possible? What transformation I can use for this?
Appreciate the help.

324 views

Hi,

Could anyone point me in the direction of a good article that explains generating a surrogate key pipeline in ssis. Including the initial load.

Many thanks

624 views

I'm trying figure out the best way to go about this, advice is appreciated.

I have 2 locations -- Location A and Location B.  Separated by WAN no VPN.

Location A is in a domain environment and …

535 views

I get the error:

Error: [TF Upsert Destination [258]] Error: System.InvalidOperationException: The given value of type String from the data source cannot be converted to type int of the specified …

313 views

SSIS package is taking too long time to load when i open. Is there any configuration to stop this validations?

329 views
Live: Real-Time Solutions, Start Here
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

In Excel worksheet one column have first 99 rows are NULL/BLANK  and then it has text data. While executing ssis package it is giving an error potential loss of data.

Thanks,
Mayank

423 views

Hi,
I have developed an ssis package to run 3 reports from reporting service that are data driven subscriptions.
When I run the ssis job it executes all the 3 reports at once, what I need is to run …

2045 views

Msg 252, Level 16, State 1, Line 1
Recursive common table expression 'a' does not contain a top-level UNION ALL operator.
I am getting above error? Can anyone help pls?
with a as
(
        …

328 views

I have an SSIS package which executes properly from Visual Studio - it dynamically creates a link to an Excel spreadsheet based on a supplied date and updates a table in SQL Server 2012. I have …

1259 views

hi experts

i have this question:

1. The cube of analysis services is physical or logical (it is constructed from the dimensional database)

2. Can an SSIS package load data into a dimensional …

335 views

hi experts

i am reading about: real-time operational analytics
in https://msdn.microsoft.com/en-US/library/dn817827.aspx

whats the mean: real-time operational analytics

133 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server
    (157,558)
  2. MS SQL Server 2008
    (49,070)
  3. MS SQL Server 2005
    (71,562)
  4. MS Development-Other
    (47,949)
  5. Query Syntax
    (47,606)
  6. SSRS
    (8,793)
  7. .NET Programming
    (131,929)
  8. Databases
    (53,700)
  9. MS Excel
    (129,433)
  10. Visual Basic.NET
    (92,125)