Importing data using SSIS Package
-
Hi All, I have an SSIS package, which is trying to import data from a flat file in to a destination table in SQL. But the problem is not all columns in the destination table should come from flat file, there are few columns that should be filled from some other SQL Server source table. Can we import data from a flat file and a table simultaneously into one table, is so how can we do that? Please help me, its urgent. I am also searching but any help like code snippet, link or even a free advice is great. Thanks in advance.
Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA
-
Hi All, I have an SSIS package, which is trying to import data from a flat file in to a destination table in SQL. But the problem is not all columns in the destination table should come from flat file, there are few columns that should be filled from some other SQL Server source table. Can we import data from a flat file and a table simultaneously into one table, is so how can we do that? Please help me, its urgent. I am also searching but any help like code snippet, link or even a free advice is great. Thanks in advance.
Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA
Change your strategy to ELT, import your data into a staging table that is an exact match for the source, all varchar columns! The use a stored proc to transform the data into your final table. This method NEVER fails in the load process because of missing columns or date formats or a number has a $ sign. Never underestimate the power of human stupidity RAH
-
Change your strategy to ELT, import your data into a staging table that is an exact match for the source, all varchar columns! The use a stored proc to transform the data into your final table. This method NEVER fails in the load process because of missing columns or date formats or a number has a $ sign. Never underestimate the power of human stupidity RAH
Have a five.
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
-
Hi All, I have an SSIS package, which is trying to import data from a flat file in to a destination table in SQL. But the problem is not all columns in the destination table should come from flat file, there are few columns that should be filled from some other SQL Server source table. Can we import data from a flat file and a table simultaneously into one table, is so how can we do that? Please help me, its urgent. I am also searching but any help like code snippet, link or even a free advice is great. Thanks in advance.
Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA
Dammed if I know why someone would down vote this it is a perfectly valid question - balanced. Never underestimate the power of human stupidity RAH