Okay, i will need more information to help you. Are you sure you are passing the file name in your file system task. It will not work if you pass...

What issues are you getting ?

You can do this using OnError Event handler, see the tabs on the development studio, it will be next to the data flow tab.

In the event handlers tab ,...

We have the packages stored on msdb. The other folders which store log files, error files, temp storage etc are on a separate physical drive which is shared between...

We are using the setup that you have described and its working well.

Yes, it can be done is SSIS. Depending upon what you want to do , you need to use the various components present in control flow of SSIS.

You can...

I think the type of connection manager you are using is not apt for the Data reader, try using the ADO.Net connection. When you right click on the connection managers...

I agree with you guys !

Thanks

😉

I agree with Ben here, you should probably try to add columns that will track the changes in that row.

You can find the look up component in a Data...

Hi Mike,

Yes, it is possible to design a package which will satisfy your requirements. You will have to use a dataflow...

With SSIS you will have option to transform the data in case you need to modify it. Else you can use the import export utility to migrate data from oracle...

You can use for each loop for this. You can put a filter such as xbuns.??? . Use this in the File text box in the collection tab of the...

Hi,

I assume that you want to add multiple destinations. In data flow you can have only one success path from a source component. But you can...

I think i have got my resolution ... i had posted this query on Jamie Thomsons Blog , he has replied to it and i agree with it .. here...

Todd , i am doing the same thing ... i retrieve two columns through the select query , the properties are as follows :

ResultSet = Full result set

SQLStatement= SELECT COL1,COL2...