creating a job for SSIS package... - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » creating a job for SSIS package...

creating a job for SSIS package...

Options

Previous Topic · Next Topic

sqladmin

Posted: Monday, September 10, 2007 5:56:05 PM

Rank: Newbie

Joined: 9/10/2007
Posts: 8
Points: 24
Location: us.fl

normally when you want to create a Job for an SSIS package
you simply go to the Management Studio -> SQL Server Agent -> Jobs
and upon adding a 'step type' you can simply use the drop-down, and
select: SQL Server Integration Services Package.

why would this not be visible in the drop down if i already have BIDS
installed?

am i missing something?

Confused

sqladmin

Posted: Tuesday, September 11, 2007 12:45:10 PM

Rank: Newbie

Joined: 9/10/2007
Posts: 8
Points: 24
Location: us.fl

can anyone add to this?

Scott Whigham

Posted: Thursday, September 13, 2007 9:31:31 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

So unnecessarily complex - so much so that I created a three-part series on it here: http://www.learnintegrationservices.com/VideoTutorials/SSIS-Tutorials/197/Series-3-videos-How-to-Schedule-An-SSIS-Package-To-Run.aspx

sqladmin

Posted: Monday, September 17, 2007 11:11:16 AM

Rank: Newbie

Joined: 9/10/2007
Posts: 8
Points: 24
Location: us.fl

yes... they are good, but while following along i still get to the part where you can see the drop down, but in
my case whenever i create a job step, and select 'type' the option the SQL Server Integration Services is not available.

sqladmin

Posted: Tuesday, September 18, 2007 2:32:06 PM

Rank: Newbie

Joined: 9/10/2007
Posts: 8
Points: 24
Location: us.fl

the only difference that i can see is that from the Client the option is available,
but not so on the server. the server has the more current version.

Server Info:
SQL Server 2005 (SP2)
9.00.3042.00
Enterprise Edition (64-bit)

Client Info:
SQL Server 2005 (SP1)
9.00.2047.00
Developer Edition (32-bit)

here's the interesting part....

how do i get it to work on the server? it's a tough one cause the Server version is
more current.

any ideas?

sqladmin

Posted: Tuesday, September 18, 2007 3:43:37 PM

Rank: Newbie

Joined: 9/10/2007
Posts: 8
Points: 24
Location: us.fl

got it now. hotfix package.

Scott Whigham

Posted: Thursday, September 20, 2007 10:10:23 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Ugh - well, at least that worked!

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.