I have a query to be used as so开发者_如何学Pythonurce. but this is a huge query containing lot of temp tables created and finally joining which brings select data. So I used Script Task for this quer
I have a WCF serv开发者_开发知识库ice that I need to consume from within an SSIS Data Flow Transformation, and I\'m trying to figure out how to go about that.
OK my first question so here goes. Currently users are using a huge Access Application. They wanted a web application with some functionality based off of the Access data and with some modifications.
I am using a custom \"Connection Manager\" that开发者_JAVA百科 talks to a proprietary database. One of the fields in the Custom Properties section of this object is called \"DataQuery\", where you can
Here is my problem. I have a first SQL task that return filepath into a Full result set (ie: \\server\\myfolder)
In SSIS 2005, how can I can detect the number of rows from a flat file? I happen to be importing a flat file to an OLE DB Destination and in case of error
I need to run a SSIS package through winforms. using System; using System.Collections.Generic; using System.ComponentModel;
I had this SSIS package working yesterday and now I\'m getting this error with no changes overnight.
I have a problem - I wish to dowload customer data via SSIS (Microsoft ETL). For each customer record I import, I have to check against existing customer records in my target DB. If the record exists,
I have excel source and sql server table . Excel Source column is MnoPrice1Price2 1111020 2223025 3334030
加载中,请稍侯......