I want to set up SQLTable package config.

1) I established a source(Source_DB) and destination (Destination_DB) connection (OLEDB connection) at connection manager level.

2) So those two connections are shared across all...

Jeff Thanks for your reply. Yeah all my packages use the same connection.But I am not able to create a sql server config because it throws an error saying...

1) I created an Integration service project

2) I created a common connection Manager for that project.

3) By sharing the same connection manager many number of packages exist under...

LTRIM(column1) == "" ? (DT_STR,100,1252)NULL(DT_STR,100,1252) : (column1) == "Y" ? (DT_STR,100,1252)1 : (DT_STR,100,1252)0

I finally arrived at the correct derived column expression.

Let me brief on this.

I am pulling the data from...

LTRIM(column1) == "" ? (DT_STR,100,1252)NULL(DT_STR,100,1252) : (column1) == "Y" ? (DT_STR,100,1252)1 : (DT_STR,100,1252)0

I finally arrived at the correct derived column expression.

Let me brief on this.

I am pulling the data from...

Jeff,

I have one more question.

I have a derived column expression like this :

LTRIM(Column1) == "" ? (DT_STR,100,1252)NULL(DT_STR,100,1252)

(Column1== "Y" ) ? 1 : 0

This Column1 is...

Thank you so much.I figured out the problem.The package path in the back end SQL table was not updated correctly.

Thank you so much for your suggestions.

Thank you so much for your time and patiece.Will follow your suggestions and let me check.Will update you once I am done.

The SERVER NAME Is same only my database name and flatfile source path needs to be changed every time.So the answer to your Question is When I change in...

Thanks for your reply..

If I need to change the Db name and Flatfile source name to the package (which is not deployed yet)

can I update the SSIS_config table at the...

Hi Andrew,

I have a problem in using SQL table for package configuration.Let me explain in detail.

I have the task Flatfile source---->(correct output) to oledb destination

...