Viewing Variable values that are passed in to SSIS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Viewing Variable values that are passed in to SSIS

Author

Topic

malawneh
Starting Member

24 Posts

Posted - 2008-04-16 : 11:37:08

Since SSIS is developed in Visual Studio is there a way to view the variable values as they are passed into SSIS? In Visual Studio I know if you hover over the variable a popup appears with the value in the variable.

I am having an issue with a variable value that is supplied through an "Execute SQL Task" it is a Directory path that is entered in through the application and used to determine where to pick up files to transfer. I have entered in the path using Fully Qualified(D:\ImportExport\CentralPrinting) and UNC (\\SQLDEVELOP\ImportExport\CentralPrinting) through both methods SSIS is telling me no files are available in the directory path. When I know for fact they do exists.

I would really love to see the variable values that are being used can anyone out there help?
Thank you all,
Mike

Michael Alawneh, DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-16 : 11:41:28

You need to make use of breakpoints. Add a breakpoint to postexecute event of Execute SQL task and check the value of variable once package execution halts at breakpoint.