SSIS package not importing into SS2008 due to dots in the name
I'm importing an SSIS package into SQL Server 2008 Integration Services . The package name contains dots and I'm getting this error message: The package name, What.No.Dots, contains characters that are not valid. The following characters are not valid: \ / : . * ? " < > | [ ] = Parameter name: What.No.Dots (MsDtsSrvr) Is this really the case with SQL Server 2008? I could import packages with dots in the name into SQL Server 2005. I know this sounds like a dumb question, but I want to double check before I rename all my SSIS packages
May 19th, 2011 4:01am

I tried with both 2005 and 2008, in both cases you can not deploy package on SQL Server with names which contains dot ( . ) . but you can deploy them in filesystem without any problem.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 6:16am

Thanks for your reply. My last project, all package names containes dots, maintained in Visual source safe. But in production all packages running fine ( DBA's taking care of production system, i guess at some point we need to put the packages in Sql server to run ) Vj
May 20th, 2011 3:41am

You probably deployed your packages as File System and this is why you have all of them with dot names without any problem. you can deploy them on file system on new SSIS 2008 server with dot names too. but if you want to store them in msdb ( SQL Server option ), you need to obey the rule for naming without dots.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
May 20th, 2011 10:06am

You probably deployed your packages as File System and this is why you have all of them with dot names without any problem. you can deploy them on file system on new SSIS 2008 server with dot names too. but if you want to store them in msdb ( SQL Server option ), you need to obey the rule for naming without dots.http://www.rad.pasfu.com
May 20th, 2011 10:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics