have a source table:
     Business Key
    Value
     1

My Source DB is on a hosted remote sql server 2005.  I created an exact
database on my local SQL 2008 Developer.  I use SSIS to import data from
remote SQL 2005 to local DB (SQL 2008 Dev) , which deletes rows in
destination tables and allows Identity Insert.  As far as I can see, ...

Am using SSIS to create an excel file. It works fine the first time but later
crashes as it ask to re creat the excel destination table. I found a solution
whch was to drop and create the table. Now my file contents are overwritten
BUT how to dynamically rename it with a proper ...

Gurus:
is there a way to have a source column copied to several destination
columns in a single destination table using ssis
Wisord

Hi SQL Server experts:
I'd like to transfer a table from one db to another. The export only
transfer data, not index, constrain or triggers. Is there another tool I can
use besides backup/restore the whole DB?

I have a conditional split that splits records into valid and invalid.
How do i send an email of invalid records to the DBA?

I have an ActiveX task in my DTS (SQL 2000) which just goes and gets a
file from a network server and puts it on a network drive.  Nothing
fancy. No checking for connections or validating the file arrives.
Works fine when I run it manually, either just this step or the entire

When trying to convert a MSSQL (2008 Express) database to MySQL (5.1)
My systems throws the following error:
Messages
Error 0xc020844b: Data Flow Task 5: An exception has occurred during

How can I determine what is causing the following package to fail?
Error: Error 0xC0012050 while loading package file "C:\Documents and
Settings\wardte\Local Settings\Temp\2\InnerPackage.dtsx". Package failed
validation from the ExecutePackage task. The package cannot run. .

My data source is an excel file. One column named [employee Id] should
contain numeric data, however every month the excel file is received with
about ten out of 50,000 records having the [employee Id] data proceeded with
a specific letter.

Here's a situation you won't find every day.
I have a big database project that I am taking over.  There is a set of
6 DTS Packages that import 6 tables from the Timberline accounting
software via ODBC every night.  A 7th DTS Package calls each one of

I used to make DTS packages on the 'older' SQL server and then add it as a
Job on the SQL Server Agent
to copy data from the mainframe computer to SQL on a daily basis.
I think I have understood that this ain't the way to do it anymore in SQL

I have a simple ssis (it just creates a table). It has a variable tblName.  
When I give a valid variable name, the ssis works fine.  In the orignial ssis
package I have tblName set up as tblTest.  I saved the ssis package in the
server.