I am building packages to migrating data from Sybase to SQL Server; however, I have problem saving my packages when it is selecting from a large table. It takes a long time for it to save, but if I limit the script to a small subset, it save faster.
Is there an option to disable the SQL Server Enterprise Manager to run the query against the db on a save?You can uncheck the Run Immediately option and just check the Save. This will only save the package without actually running it.|||Sorry, I am new to this. Where is that option?|||What's the source (Access?) And it's across the Network?
Yeah I had that problem...I created a shell empty access db, and it's quick...I thought is was because of the large number of objects, and had to spin through the collection to "find" that table.
But yours sounds different...are you sure it's the volume of data?|||On the Source Tab of the DTS Properties, I added the where clause to look for only one record and it saves immediately. The script is doing a select from a Sybase environment and pump into SQL Server.|||How are you creating the dts package - Import/Export wizard, dts editor, vb ?|||I am building the packages in the dts editor.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment