Hi anyone can suggest best Zip/Unzip Task for SSIS. We want to zip several GB files. I just found a product called TaskFactory looks very promising but wondering if anyone used it http://www.pragmaticworks.com/Products/Business-Intelligence/Taskfactory Thanks ...
We have a process that is getting data in real time and adding records to a database. We're using SQL Server 2008 Integration Services to run our Extract Transform Load (ETL) process. We download about 50 files from an FTP site, process them and then archive the files. The problem is that the processing is taking about 17s per file even...
Hello, I have configured MSMQ on my machine. I have created 1 Public Queue and 1 Private Queue. I am able to send messages to my private Queue when I use machinename\private$\testQueue But When I send the above queue name to our DBA team. They are not able to send messages to this queue. How will they be able to send messages to the abo...
Running SQL Server Integration Services (64-bit install of SQL Server 2008 Developer) on a 64 bit version of Windows 7 Professional. I have a simple SSIS package which imports data from a delimited text file, does a lookup to a SQL Server table, joining on a key field (int) and returns the UserName (varchar(50)) from that table. Sample...
I'm wondering if SQL Server Compact Edition can be used as both a Source and Destination in an SSIS dataflow. I know I can setup a SQLMOBILE connection manager, and I've found some information that mentions using it as a Destination, but nothing on using it as a Source. What I'm looking to do is to transfer data from one SQL Server Com...
I have the following Data Flow task in my SSIS package: It reads a file from an external vendor that has records with a column "change" that cointains A, C or D for add, change and delete. I have to process these in my SQL Server database. The conditional split checks the value of the change column and sends the row off to the appropr...
When am using sequence container to roll back my transactions in execute sql task i am getting the error Connection manager Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025 "The partner transaction manager has disabled its support for remote/network transactions.". hav...
I have created a very simple Data Flow in SSIS that is run inside a loop. I have a simple OLE DB Source control which is connecting to a SQL Server and running quite a complex query to split daily data by 30 minute intervals as shown below. I then have a Flat File Destination control which is taking the output from the OLE DB Sourc...
I have a data viewer attached to a transformation to show me the data as a grid. At the bottom is says total rows 22002, rows displayed 9964. How do I get it show me the remaining rows? I've tried clicking and right clicking on everything! ...
So I made a package in SSIS to read data in from a text file and load it into a database table. What's the best way to set this up for non technical end users to run this when desired? My boss was thinking to have a SP launch it, and then have a report made in reporting services launch the stored procedure. Surely there's a better w...
k i think i have spent way to long on this one. So here is what i am doing. In a ScriptTask I am trying to retrieve a file from a networked location and FTP that file to an offsite location. In SSIS i created the FTP Connection and tested that it is setup and works. Created Three Variables (because i tested this a million ways) variab...
Does anyone know if it is possibble to use SSIS with Amazon RDS? Since RDS is essentially MySQL - would this be possible using OLE DB or something...? ...
Is there anyway to import data into SSIS where I expect the PKs to be sequential guids? The only method I've been able to come up with so far is to create a temporary table with the column defaulting to newsequentialid() loading the data in there then copying it to the correct table. This isn't very elegant and is somewhat time consumin...
We are creating several SSIS packages to migrate a large database as part of a release cycle. We may end up with about 5-10 SSIS packages. As we have 4 environments (dev, QA, staging, production, etc.), is there an efficient way to change the destination server for each SSIS package as they go through the different server environments...
I'd like to move 26 tables from one DB to another. I see I can do this in the SSIS Import and Export Wizard. I believe the other approach would be to select tools from the toolbar in Data Flow and then configure them all. When is it better to use the wizard and when is it best to create the package manually (with the visual tools) or ...
Is there a way to debug .Net dll from SSIS Script Component which is being referenced. Thanks ...
Can anyone point out some good samples / examples on Custom Dataflow Component (Transformation) other than one on codeplex. Thanks ...
I have a somewhat complex query that I want to use as a source in an SSIS package. I create my OLE DB Source, specify the access mode as SQL, and paste my query in the command textbox. When I click Preview, sample data comes back and everything looks good. However, when I try to run the package I get back "external columns are out of sy...
I was wondering if I can get a 2008 SSIS package to reference .NET 3.5 assemblies? In my case I want to use LINQ-->XML so I can make use of XML literals in a script task. (Otherwise I need to deal with a large number of string concatenations.) NOTE: I know I can use a C# script task and declare my string as String myString = @"This is ...
I am trying to load data from a single file (with million+ records) into multiple tables on SQL Server using SSIS while maintaining the relationships defined in the file. To better elaborate with an example, lets assume I am trying to load a file containing employee name, the offices they have occupied in the past and their Job title h...