I have a connection string ="/f c:\test\test2\test2\package.dtsx /set \package.variables[User::varfil].Value;" & Parameters!varempid.Value but its not returning any results. I need a valid connection string.

When you run the SSIS package similarly with DTEXEC do you get results?Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Hello, What are you trying to achieve with this? SSIS isn't a datasource, it's a ETL tool.Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich http://olafhelper.over-blog.de

Hi zoomwell, The ssis parameter syntax is wrong in the connection string. The complete string should be something like this: ="/file c:\test\test2\test2\package.dtsx /set \package.variables[varfil].Value;" & Parameters!varempid.Value more details about this, see http://blogs.msdn.com/b/bimusings/archive/2006/07/19/using-a-parameterized-ssis-package-as-a-data-source-for-sql-reporting-services.aspx. if you have more question, please feel free to ask. thanks, Jerry