Hi, I have a bunch of SSIS packages that I am trying to deploy to SSIS. But when I try I get the message The scale is invalid. (Microsoft SQL Server Native Client 10.0) Does anyone know what the problem is? Thanks, Zoe

I think that this is fixed in 08 SP1 and in 06 CU 6. I think it is related to this KB article... http://support.microsoft.com/kb/972498 Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/

Are you sure? Im running Version 10.0.4000 Im not actually trying to run the Packages - Just deploy them to the msdb (right click in SSMS > Import Packages)

See also this forum thread with the similar subject/error: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/028c571e-5143-4c63-8dda-1834dc4818b2/ Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

I followed those directions, but it looks as though my Config file was correct. I restarted the service, but still no luck (Its the 3rd instance Im trying to deploy to. <?xml version="1.0" encoding="utf-8"?> <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB1stInstance</Name> <ServerName>1stInstanceConnectionString</ServerName> </Folder> <Folder xsi:type="SqlServerFolder"> <Name>MSDB2ndInstance</Name> <ServerName>2ndInstanceConnectionString</ServerName> </Folder> <Folder xsi:type="SqlServerFolder"> <Name>MSDB3rdInstance</Name> <ServerName>3rdInstanceConnectionString</ServerName> </Folder> <Folder xsi:type="SqlServerFolder"> <Name>MSDB4thInstance</Name> <ServerName>4thInstanceConnectionString</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..\Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration>

to exclude package errors... Can you deploy (the same) packages to other instances on the same machine?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Thats for the help eveyone. Dont know why, but it seems to let me deploy them straight to the MSDB through BIDS (just not through SSMS) Dunno why...