I am running SQL Server 2005 and trying to make a copy of a database from
Management Studio.  Using the Backup wizard I go through all the steps that
you would normally walk through to make a copy, and actually start the copy,
but when I do I get the following error message from ...

I last developed SSIS in Oct 05 and this bug was a major irritant. 18 months
later I'm revisiting the same deployment and it's annoying me all over again.
I'm wondering if one of the service packs has fixed it in the meantime?
Thanks in advance

I am going to use the SQL Agent to schedule my SSIS Job.
However, I only want my SSIS Package to run if a flag in a table has been set.
This flag is set by another job/process which someone else in my company
developed.

I would like to run a ssis package and pass the filename as the parameter to
the package.
This is what I have worked out so far but notice the error message:
xp_cmdshell 'dtexec.exe /f

Can I call an SSIS Package from a Stored Procedure?

Using SSIS, while importing (source i.e. .csv into destination i.e. sql
server table), how is it possible to log the source COLUMN which causes the
error in the row?
Thanks

Using SSIS, how is it possible to execute another ssis package and pass a
parameter to it?
For example, I would like to have a sql code that runs the package say
"d:\sysappl\CEM\SSIS\CSA.dtsx" and pass a parameter of fileName because the

I create a Execute task that sets a boolean value of whether or not to
continue the processing of the package  How do I evaluate that
variable to determin whether to continue of fail.  In DTS I would have
written and ActieX script and giving it a status code but I do not see

I am using a foreach loop to go through the .txt files inside a folder.
Using a variable I can pickup the filenames the loop is going through.
At present there is a sql task inside the foreach loop which takes the
filename as a parameter and passes this filename to a stored ...

I am having trouble with the pivot transform. My desired results are not
quite like the examples I have seen in the Help, and I am wondering if the
pivot transform is the right tool to use.
I have source data that is similar to the following:

I've got a delimited text file that aprox 5.5GB that I'm trying to
load into a table on SQL 2000 (Windows Server 2003) and I keep getting
the error "Not enough storage is available to complete this
operation."

(Re-Posted from another site with permission, since I have the same
problem and he stated the issue well:) -- David Walker
Kirk Shanks
Uploading Text File with Header and Trailer Records

SQL Server 2000 SP4.  I built a large DTS package that grabs a number
of tables from an Oracle DB, does some scrubbing, updates, and date
verification
and loads to a SQL Server DB.  Most of the tables are full refresh

In SSIS, what toolboox item can I use to pull the disinct rows from a flat
file that has repeating data.  I am trying to do this without importing the
data into staged table then use tsql to pull distinct values and load the
production table

I'm Using a VB Script (ActiveX Script Task) to create a connection and a recordset to a specific database in the local server.
I dont want to name the server explicitly in the connection string because the DTS package would be installed in another server with another name.
How ...