var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have created SSIS (.dtsx) files and have stored in different servers.
Now my query is I want to move all dtsx files from filesystem to Sqlserver2005 database how should i do it.
I think this has to be done one at a time for each package. Open it and do a SAVE AS with the new location.
If it's not practically useful, then it's practically useless.
There are lots of ways to do this, and it can be done progmatically (using SQL-DMO), but based on the information you've posted so far I would go with Blindman's suggestion of opening the packages and manually saving them into SQL Server.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors