I am not sure if this is the right group for this post, but I did find
some other SSIS topics.

I opened up the "New Project" screen, and Data Transformation Project
is not available as an option. The only new project options I have are
SQL Server Scripts, Analsys Services Scripts, and SQL Mobile Scripts.
Also, I only have the templates window (which is where the three
options are located. I cannot see a Project Types window. Does anyone
know why I am not able to start a new SSIS project? I checked the
installation, and Integration Services is installed.

JeffWeight (AT) gmail (DOT) com wrote:
Check the about screen, you should see SSIS. Example here -
(http://wiki.sqlis.com/default.aspx/SQLISWiki/BIDS.html)


--
Darren
http://www.sqldts.com
http://www.sqlis.com

Ok, so I need to develop Data Transformation Projects in Visual Studio,
not in the Business Intelligent Development Studio. I looked up a
couple of instructional articles on developing SSIS, and both listed
opening BIDS as a step, not Visual Studio. Your article helped me to
understand that Visual Studio 2005 and BIDS are the same IDE shell.
Thanks for your help!

great info!

a question though, so once u create a IS package in VS2005 (design mode),
what are the steps so u can schedule the IS package in sql2005? (ie compile
the package
then how do i sched that in sql 2005? )

thanks!


"JeffWeight (AT) gmail (DOT) com" wrote: