August 5, 2008 at 3:41 pm
I have created an Import/Export wizard ans saved as ssis pkg but where can i find it so that i can set it up as a daily job?
August 5, 2008 at 4:38 pm
Did you save the package to SQL Server or as a file? Connect to Integration Services on the server where you saved the package and look in Stored Packages - either File System or MSDB.
When you create the job in Management Studio, choose "SQL Server Integration Services Package" as the step type. You can then specify the package location.
Greg
August 5, 2008 at 4:57 pm
when i connect to Integration SErvices under tht MSDB
i get an error
" Failed to retrive data fro this request.(Micorsoft.Sqlserver.SmoEnum)
Additional information:
Login timeout expired
An error has occured while establishing a connection to the server.bla bla bla...
August 5, 2008 at 8:23 pm
type the folowing in commond promt will list u all the ssis packges
1. cd2. dir/s *.dtproj
August 6, 2008 at 11:52 am
Mike,
I haven't seen that problem myself, but does this help?
http://forums.microsoft.com/msdn/showpost.aspx?postid=75967&siteid=1
Greg
August 6, 2008 at 1:25 pm
is it OK to change the file MsDtsSrvr.ini.xml? am worried if it will mess up something else on my server.
WHat should i change there
August 6, 2008 at 1:45 pm
its resolved, i can look into the package now but looks very much diffrent when comapred to DTS pkg.
How could i make it as sql job and also need to add some sql scripts to run before and after executing the package.
August 6, 2008 at 2:40 pm
See my first response for how to add a job step for executing a package. You didn't specify what your scripts do, but generally you can just put them in separate job steps before and after the step that executes the SSIS package..
Greg
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply