jameslauf (2/4/2014)

---

Hello I need a little more help with the SQL task to Variable.

I have made a SQL Task and set the result to Single Row and put in my...

jameslauf (2/3/2014)

---

New to SSIS have done mostly Import Export wizard jobs with small modifications.

I have a Flat File Source that has 30 columns and a Destination Table that has 31...

Perhaps you could try this.

1) Send all of your potential updates to a staging table.

2) Do a Merge from the staging table to perform the update using a source something...

DaveDB (1/24/2014)

---

This comment is very insulting.

"Perhaps the reason for my request for additional material is becoming clearer now.

The fact that accomplished professionals, who would usually be able to...

Well done. Quality coding takes time, but pays off in the long run 🙂

I have just downloaded SQLEnlight and started evaluating it and would be interested to hear any other comments about this product. My intention is to use it primarily for static...

+1

I'm using a simple set up. Excel Source---Data Conversion (for the routing ID column) and an OLE DB Command

If anyone knows a work around or knows exactly how to fix...

nonghead-webspam (1/17/2014)

---

So, if I want to do extensive variable and data manipulation in the process, is it better to use an external compiled module? I've done that in the...

Have a look here for an example of importing multiple files with the same format.

Please post an example of one of these.

kenneth.mofokeng (1/16/2014)

---

try this , u can change it and use sp_msForEachDB to loop around all databases

SELECT sc.name +'.'+ ta.name TableName

,SUM(pa.rows) RowCnt

FROM sys.tables ta

INNER JOIN sys.partitions pa

...

It's quite advanced, especially given your experience with the product, but this article is relevant.

Also, as others have mentioned, please stop referring to multi-tab CSV files: they do not and...

OK, please provide some sample data, DDL and desired results in...

polkadot (1/14/2014)

---

Actually, that's what I meant. I have nothing in the CollectionString property. I should not have said that I added the variable to the ConnectionString property, rather I...