Thank you for the reply Gila..

I have an SSIS package. I am running the SSIS package parallely by passing two different variable values to it. Lets assume that the package...

I have done it in the report. In the report its showing the data correctly. The problem is only when I am exporting to CSV file.

Other Exports are working fine.

I recommend you to go through this link

http://www.bidn.com/blogs/BrianKnight/ssis/59/what-are-the-advantagesdisadvantages-of-storing-ssis-packages-to-msdb-vs-file-system

It does not return any error when i ran in SSIS. The package is stored in the file system.

Thank you all for the replies..It worked..

Thank you Gila..It worked for me.but just want to know Is there any disadvantage in using local temporary table?

Each dynamic SQL Statement that gets generated has to be joined with the Temporary table.

I have posted the Sample Code there.In the Original requirement the SQL statement is dynamically generated. It works if i do this way but it will be a recoding again...

Hi Anthony,

Is it like I should not use that query when I want to retrieve all the tables from a single database.right?

Anthony,

I need all the tables from one database not from all the databases. Please tell me whats wrong with the following query

sp_msforeachdb 'USE [Chapter]; SELECT * FROM sys.Tables'

I clearly...

No Anthony. When I query "Select cont(*) from Sys.databases" it returned only 9..not 23..

the thing is same output is being returned for 23 times.

I have the database name stored in a variable. lets say my databse name is 'chapter' .I want to retrieve all the all the table names of the database "chapter"...

yes, I know the other way, but I want it using "sp_msforeachdb" . Please suggest

Thank you. It worked.

Hi Keon,

I activated the logging in SSIS Package. I came to know where it is hanging. Its trying to execute a Select statement which is joined with Some other tables....