I would like to create a text 开发者_运维知识库file with some data i am manipulating in a script component and write it to a text file.i know how to write it to an existing text file, but what i would
I want to use the SSIS Package Configuration to change the path of several flat file destinations, but only the path, not the filename.Basically I have alot of flat files going to the same directory,
I have a flat file stored locally on the same server where SSIS is running. 开发者_Go百科When choosing the location of my flat file in the flat file connection manager, I could use the local drive (d
I\'ve written an SSIS package which reads all the worksheets fr开发者_高级运维om an Excel workbook into a database.
I have an oledb source which i have hooked up to a script component.The Script component is configured to the oledbdestination.There are 70 rows which I am importing to the destination.If i select the
I\'m getting an error with an SSIS package which I\'m not sure how to开发者_JAVA技巧 fix. I feel I will need to give a background as to what I am trying to do to help you understand:
Rather new to SSIS so not sure how to handle t开发者_开发问答his. I have a flat file which i managed to successfully read from. So right now my data flow consists of just a flat file source.
I don\'t entirely understand the purpose of control flow in an SSIS package.In all of the packages I\'ve created, I simply add a data flow component to control flow and then the rest of the logic is l
I havea table with 48 fields, i am filtering some data and need to use a script component( i need this for 10 of the fields in which i am actually changing the data)on the other 38 fields I only want
how to convert SSIS packages into Cloud azure. Also please can you tell me something about SSIS packages and what is not supported 开发者_运维知识库in CLoud.SSIS is not supported in SQL Azure at all