ssis

SSIS gurus: Links to Great Learning Content requested

Okay, you don't need to be a guru, but if you happen to have a good working knowledge on SSIS and you used some tutorials around the web to get you there, then please share them. I have been trying to find some solid stuff (screencasts maybe), but I am having a hard time. Any solid links would be appreciated and I will add them to this...

SSIS read flat file, write to DB or C# app,mutli thread read/write?

Within SQL Server Integration Services (SSIS) there is the ability to setup a connection to a flat file that can hold millions of records and have that data pushed to a SQL DB. Furthermore, this process can be called from a C# app by referencing and using the Microsoft.SqlServer.Dts.Runtime namespace. Would a flat file with millions of...

SSIS: Remove Duplicates from Flat File

Let me first say that being able to take 17 million records from a flat file, pushing to a DB on a remote box and having it take 7 minutes is amazing. SSIS truly is fantastic. But now that I have that data up there, how do I remove duplicates? Better yet, I want to take the flat file, remove the duplicates from the flat file and put the...

Recommend ONE favorite SSIS component that does SFTP/FTPS

Sometimes normal FTP doesn't quite cut it... When you need to do secure FTP via SSIS packages, what ONE product would you recommend? Before answering, please see if someone has already suggested the same thing and, if so, vote it up. NOTE: Ideally, it needs to handle both SSH and SSL FTP connections, but I'd consider two separate comp...

How to turn on FastParse in SSIS (SQL Server Integration Services)

The book that I purchased to help with my SSIS understanding seems to have glossed over this, and I wanted to know exactly what is the method to turn on FastParse in SSIS? ...

SSIS (DTSX) Execute package failing on production server.

So I have created a SSIS package and it works great on my dev machine. But, when I try to run it on the production server, it errors our on me. Here is there error: Error: The AcquireConection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009. I have figured out the cause, but am ...

Sql Server 2005 SSIS unable to enlist SYBASE distributed transaction

Good morning, I know very little (arguably nothing) about SYBASE setup, but I do know SSIS is having trouble enlisting SYBASE in a distributed transaction. Has anyone been able to make this work? The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x80004005 "Unspecified error". This h...

How can I call SSIS programmatically from .NET?

I have an application where whenever a file is uploaded to a directory, I have to call SSIS to parse the XML file. Can I call a SSIS directly from a .NET Windows service? ...

How can I have my polling service call SSIS sequentially?

I have a polling service that checks a directory for new files, if there is a new file I call SSIS. There are instances where I can't have SSIS run if another instance of SSIS is already processing another file. How can I make SSIS run sequentially during these situations? Note: parallel SSIS's running is fine in some circumstances, wh...

Create SQL Table from Excel spreadsheet

Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some tool? Thanks in advance. ...

Move SSIS Packages from SQL Server 2005 to 2008.

What are best practices for moving/exporting SQL Server Integration Services Packages from a SQL Server 2005 DB over to 2008? What are some of the security concerns? ...

SSIS - query another row in current data pipeline for a value

SSIS - I have data loaded and various transformations on the data complete, the problem is there is a parent/child relationship managed in the data - best explained by an example each row has (column names are made up) row_key parent_row_key row_name parent_row_name some rows have row_key == parent_row_key (their own parent) some rows ...

Passing a variable to dtsx package results in unexpected precedence constraint evaluation

I have a dtsx package with a precedence constraint that evaluates an expression and a constraint. The constraint is "success" and the expression is "@myVariable" == 3. myVariable is an int32, and when set in Visual Studio's design GUI the package executes fine. There are two other paths that check for the value to be 1 or 2. However ...

Should we upgrade to SQL Server 2005 or 2008?

Our company is considering upgrading our SQL server. At this point, would it be better to upgrade to 2005 or 2008? Here are some of my considerations: Features Licensing costs Learning curve Bear in mind our staff has already been using SQL server 2000 for many years. ...

Remove last record from the text file!

What's the easiest way to remove last row from the text file using SQL Server Integration Services? Thanks. ...

How to export a flat file with different rows using SSIS?

I have tree tables, Customer, Invoice and InvoiceRow with the standard relations. These I have to export in one fixed field length file with the first two characters of each row identifying the row type. The row types have different specifications. I could probably do it with a nested loop in a script block, but this is my first ever ...

How to programatically create an SSIS Package?

I am trying to programatically create an SSIS package containing a simple data flow from table A to table B in the same database. I am using the example given here. The package gets created and saved to a dtsx file, but when I open it in visual studio I see that the source and destination tables have not been selected. I also want to i...

I need DTS to survive, which edition of SQL Server 2005 should I buy?

I heard about SSIS, a new replacement of the old DTS. I believe it has the same functionality which I used to perform. Now, like any other product from Microsoft, you have to mess with 10 different choices for a single package. I would like to get your opinion of which edition of SQL Server 2005 I should buy to ensure that I can replica...

Automated unit testing SSIS packages

How can I unit test SSIS packages? I want to be able to create and maintain unit tests for various components such as the workflow tasks, data flow tasks, event handlers, etc. Are there any existing techniques, frameworks, and/or tools that can be used? ...

Is it possible to use relative paths for SSIS packages dtsConfig files?

I am trying to make our SQL Server Integration Services packages as portable as possible and the one thing that is preventing that is that the path to the config is always an absolute path, which makes testing and deployment a headache. Are there any suggestions for making this more manageble? Another issue is when another developer get...