manikam_sundar (2/10/2013)

---

Hi friends,

This is my first post in SSC, Im new to SSIS .,

Scenario : SOURCE SQL DB NAME 'A'

...

Looks like you have not installed SQL Server / SSIS.

PaulB-TheOneAndOnly (2/8/2013)

---

rs80 (2/8/2013)

---

Can a slowly changing dimension be used to insert/update records into a staging table? I haven't used that transformation before and from what I read it was more...

Have you considered a pure (ish!) SQL solution?

Haven't got much time right now, but have a look here[/url] & see whether it might be useful.

Please explain what you mean by "registers them in a log table" - are you actually processing the files or just recording their names?

namrata.dhanawade-1143388 (2/8/2013)

---

Hi,

In our SSIS package we have a lot of stored procedures which get called via a SQL task. These SP's sometimes have a union all or joins between lots...

That link is from 2007 - perhaps MS have modified their web site in the last six years ...

johmga26ssn (2/7/2013)

---

I have just read more closely ... I had thought the board was 2 dimensional. Yes, you just need a println() once you have printed the array: it doesn't...

rmatthias001 (2/7/2013)

---

Newbe question. I want to establish a key(either primary or unique) on a table that will receive a bulk load that is the output of an ssis package. Will...

Yes it can.

Please reread Anthony Green's post.

I'd say that your first task would be to get the package transferred to a location which is local to the server.

If you are using an RDP connection, that should...

opc.three (2/6/2013)

---

J M-314995 (2/6/2013)

---

If there is a way to import files using a wildcard character without having to rename the files (using a static file name), I'd sure like to...

Thanks for posting back - glad to help.

OK, I fixed up your sample data to use a proper IDENTITY PK and not to try and insert varchars into the INT bank_id column. Solution below:

IF OBJECT_ID('TempDB..#mytable1','U') IS NOT...