Guys I have been given a task where a client gives me a source in the form of .tx or .csv format. I am requested to output the outcome as...

Hello Jacq

Well try using DataSource and its ADO.Net editor in the Data Flow Task to connect to sybase, if not go back and use DTS which is 2000 version to...

Hallo there rookie...

After the you have done your calculations or whatever transformation you have done, try converting again so that your data type will match with one in the destination...