Scheduled SSIS

Hello all,

I was very familiar in creating quite complex DTS packages in SQL2000. Now with 2007 that is all gone. I looked at the command line utility and it's UI counter part but these are just for executing. I keep getting references to the SSIS designer but I can't find where it is.

Can someone point me in the right direction?

Thanks,

Jesse

So, dtsrun.exe has now become dtexec.exe and it's counterpart on the UI is dtexecui.exe. The UI you see in the UI there is the same type of ui you'll see in the SQL Server Agent job. You'll just simply need to select SQL Server Integration Services for the step type and you'll get the same screens.

Brian

|||The designer components is installed when you select Client/Workstation components during SQL Setup. Run SQL Server Business Intelligence Development Studio, create new Integration Services project, now you have a package to design.|||

Yes I did that but when I open SQL Server Business Intelligence Development Studio it just looks like a standard visual basic studio that there is nothing under new projects that says intergration services project.

Do I just have a bad install maybe?

|||BIDS is a standard Visual Studio, but in the New Project dialog it should contain Business Intelligence Projects folder, with Integration Services Project in it.|||

I found it!

I feal incredably greatfull to everyone that helped and incredably stupid for not spoting earlier.

Thank you all.