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)  "/" variable changing value

Author  Topic  tacket Starting Member 47 Posts Posted - 2007-05-09 : 12:24:18 I have an interesting case that's happening. I'm passing in a server name and database name into an SSIS variable and trying to do an execute sql task based on these values. My server name is stored as server\pub. Ok, now here is the interesting part. If I add breakpoints and watch this variable in SSIS locals the variable becomes server\\pub. In then proceeds to fail the package because it can't connect to server\\pub. The other interesting thing is that the same exact package works on our dev SSIS box, just when we moved it to our prod SSIS box it's doing this. Has anyone ever seen behavior like this? I'm almost sure it's got to be a bug. Thanks, Phil