I have SQL Server 2000 databases that need to be converted to 2005.  The
schema in 2000 is radically different in 2005 and I wish to utilize SSIS to
do this.  What is the most efficient way of doing this?
In 2000, I would simply use a DTS package using the vbScript object to

Anyone had any joy getting SSIS to run a sqlcmd file?
ie with sqlcmd instructions in it, like :connect, :out etc ?
Thanks
wBob

http://msdn2.microsoft.com/en-us/library/ms403355.aspx#
Hi All,
I see this example to execute a pkg from web services but how can I pass
parameter using this method?

I just installed Office 2007 a few days ago.  I upgraded from 2003.
If you want to export to Excel, I understand that you have to use the
"Microsoft Ofice 12.0 Access Database Engine OLE DB Provider".
When I select the provider, there is a button for properties.  When I click

I want to setup permission for one of my users only to execute a package
that is in my msdb IS folder.
How can I do this?
The pkg I design using windows authentication with administrator

We are looking at using SSIS to import several tables into a staging
database.  The client can either give us several .txt files
representing the tables, or one .mdb file containing several tables.
It is up to the client to provide us the file(s) in a reasonable

Hello I want to convert a datetime to a julian day. TSQL has a DAYOFYEAR
function but SSIS Expression builder does not.  
Is there a way to calculate the day of the year in SSIS expression builder.
For example Today, March 28th, 2007 is the 87th day of the year.  I am

I am just starting to use SQL 2005 and seem to have hit a bit of an issue
with the Data Import Wizard. The problem I am having is, I have an excel file
that holds 4 columns Table_Name, Column_name, Data_Value, Correct_value. In
the table I am trying to populate they are all ...

I'm running into an unspecified error trying to configure a lookup in the
data flow task. It occurs immediately after the clicking the columns tab in
the lookup transformation editor. The reference table is configured and data
is returned in the preview window. The following is ...

Looking for a step by step example on how to put together a Slow Changing Dimension task in SSIS

When running a package, I am getting the "product level is insufficient"
error.  Have noticed the threads saying to fix this problem by installing
SSIS.  I see SSIS as an item in the menu bar for Visual Studio- doesn't that
mean it's installed?

I'm integrating address records from CSV files to SQL via SSIS.
 Is there any way to validate the records in the CSV files against a
SQL table to restrict which records get integrated?
 For example, I'm integrating customer addresses, but only want to

Microsoft provides a report pack of RS reports to use with Integration
Services standard logging.
The link is here
http://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad5-4a54-b62c
-13ffcd114a73&DisplayLang=en

I suffer a strange issue, sometimes a package load empty rows.
The number of rows returned by the OLEDB connection is correct but the
content is empty.
If I execute the package a second time I see the correct result!!!!

I have a SSIS package that transfer data from DB2 to SQL 2005.
Sometimes it works, sometimes it fail.
How do i troubleshoot?