If the Column Names being used in the Where clause are not in any other tables, then you might want to remove the tableName and just use column Names instead..like...

Try using your SQL as part of expression and Use that Variable as your source in OLE DB source/ execute SQL task.. That way you will be able to see...

Did you try using the actual Table Name instead of alias... That might just do it.. If it does not work try using [TablName].[ColumnName] instead.. This might sound silly...

Since you have a separate import for each server and just have to add the Server Name.. Did you try using Derived Column to add your server name?.. each import...

Since you say that its only a single Sp . I would recommend...

are you using same stored procedure to insert rows into two different tables.. If so did you try inserting them using data flow task with one source(SP) and two destinations.....

I have always seen that conditional split acts weirdly when checking for NULL columns..I have also seen...

I would take the approach that Elliot suggests

"likely do a query from each that subsets the table down to as little information as possible and write it to a...

This might help

Bring...

I would suggest using a script task because it helps you split them as you need. Even derived Column will do but using script task will give you more flexibility.....

I use the below script to check file existence on a FTP server.. This should work for you..It uses two variables FileExists and FTPPwd... after the Script task use FileExists...

I agree with Dan. There are multiple ways of doing that.. the other way would be to write a distinct(year) in Execute SQL task in a way that it returns...

ganeshlohani (3/11/2010)

---

It is not easy to send you the whole package. I will try in my next postings.

However, lat me explain you again in simple case.

SSIS PackageA has 3...

udaya_1222 (3/10/2010)

---

Thanks Devyanth , Sort transformation was helpful but now i have a question how should i build my data flow to capture duplicate records in a file and what...

You can use sort Transformation and check the option "Remove...