I have to create a Windows Form application which would modify the connection sring values present in dts config file and then execute the package with this updated dts config file.
My organization is upgrading to SQL Server 2008 from 2000 (yay!) and I am unfamiliar with the inter workings of Integration Services.
I have a flat file which is imported into SQL Server via an existing SSIS package. I need to make a change to the package to accommodate a new field in the flat file. The new field is a date field whi
I\'ve got the following directory structure: Folder A sub-folder 1 sub-folder 1.1 file.xls sub-folder 2 sub-folder 2.1
Observe the following snippet of an SSIS package: Both of the Flat File Destination tasks on the right are configured to write to the same Flat File Connection Manager, because I want all the faili
Goal: Combine two column named first and lastname, from the same table A and then transfer it to column fullname in ta开发者_开发技巧ble B from a another
I have to send a file开发者_开发知识库 to another site via SFTP.I\'ve been given a HTTPS URL with an ID/PW. When I access the URL in my browser I see a login page.
I have two databases.My source looks like this: FirstTable ------ TestingData ----------- Test Values go here
I have an SSIS package that loops through a folder and imports all the excel files into an OLEDB destination. The package works fine as long as all the worksheet names are set to default. It br开发者_
In advance I\'m new to SSIS. I run a query that gives me distinct values in columnA from TableA that needs to be processed in order (1 then 2 then 3 and so on but the numbers constantly change start
加载中,请稍侯......