April 22, 2009 at 8:27 am
I successfully migrated a DTS job to SSIS using the migration wizard, however I can't find it anywhere in SQLmanagement console.
I looked in SQL Server Agent group but I don't see it anywhere. I saved a migration log which reads at the end:
LogID=12
#Time=10:08 AM
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Successfully saved the package "Natural Health Ad Sales Report" in the destination "LEFDATA2\Natural Health Ad Sales Report".
How can I find it so I can test it, and did I do anything wrong during the migration?
thx,
John
April 22, 2009 at 9:14 am
You migrated a DTS package to SSIS, not a job, so you won't find it in SQL Agent. You'll have to create the job seperately.
To see the package in Management Studio, connect to Integration Services on the server where you saved the SSIS package (LEFDATA2). You should find it listed under Stored Packages - MSDB. You won't be able to open it here. To do that, you need to open the package in Business Intelligence Development Studio (BIDS).
Greg
April 22, 2009 at 9:20 am
Greg,
So what do I need to do to see the former DTS job in SQL Server AGent? Is that not possible?
April 22, 2009 at 9:34 am
Where did the job originate? Is it still in a SQL 2000 instance? If it is, you can script it out and run the script in Management Studio to create the job in SQL 2005.
...or are you again referring to the package? If you want to run the package in a job, create a job with a step defined with the type "SQL Server Integration Services Package". You'll be able to select the the package there.
Greg
April 24, 2009 at 7:12 am
Thanks Greg, I ended up migrating the DTS pckg in BIDS; built it to our SSIS share folder, then from Mgmt Studio I created a job and added the SSIS job as a step; so it's available thru SQL Server Agent now.
April 24, 2009 at 9:35 am
There you go. Glad you got it working.
Greg
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply