Perhaps you have a package configuration in effect? - open the package in BIDS, SSIS menu -> Package Configurations & see if you a configuration set with the connection string...

All the files are listed but there is a column "IsPresent" to indicate whether a particular file is actually included in the backup set.

I think it needs all the files...

The short answer is "the end".

Paul Randal does a great long answer here:

http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx#id0980008

Hi - One difference by running your package as a job is that by default it is now running in the context of the SQL agent Service account where as...

Sounds like a data flow using "Union All" is the way to go then....

I don't think you will find a tool to do this for you - you will just have to re-write the functionality of the package in T-SQL manually & the...

Personally I wouldn't use an expression just run your T-SQL in a Execute SQL task - e.g.

SELECT CONVERT(VARCHAR(10),DATEADD(DD,-(DAY(DATEADD(MM,1,GETDATE()))-1),DATEADD(MM,-1,GETDATE())),120) as Column1,CONVERT(VARCHAR(10),DATEADD(DD,-(DAY(GETDATE())),GETDATE()),120) as column2,

CONVERT(VARCHAR(10),DATEADD(DD,-(DAY(DATEADD(MM,1,GETDATE()))-1),DATEADD(MM,-12,GETDATE())),120) as column3

Then set the Execute SQL task "Result...

If I understand your problem correctly as long as all the tables have the same schema (ie same columns and data types) you just need to feed the output from...

Hi - I *think* your problem comes down to the fact that SSIS cannot tell what columns will come back from a Stored Procedure. A different set of columns could...

The only other possibility I can think of if the table is small is that the SSIS connection is being blocked by another process accessing the table??

Perhaps run SP_WHO2 &...

If you want to update data in a dataflow you are probably better off with the "OLEDB Command" transformation rather than a script component.

Perhaps use a derived column transform? - though that wil be pretty labourious as well I guess...

Something I often do is "create" the columns in the original select statement (asumming...

Do you have any lookups in your Dataflow?

SSIS has to cache all the data used for lookups before it can start the dataflow & if you are using very big...

OK - fair enough I stand corrected & I learned something 🙂

TheSQLGuru (10/27/2009)

---

SinisterPenguin (10/27/2009)

---

TheSQLGuru (10/27/2009)

---

1) the first poster is incorrect. you CAN get performance increases from partitioning without multiple filegroups - sometimes vast improvements even. This would come from...