Hey,

SSIS doesnt have the same level of "self-documentation" that you would get on Datastage for example, where you can export the job as HTML and all the metadata is displayed...

I am assuming that you want to upload to a FTP destination from a local path.

So you would require the remote FTP path in your FTP task, as well as...

Hey James,

Does this mean that your problem was solved?

Actually quite nicely done, using a for each ADO loop and setting the connectionstring dynamically from there.

Had a similar situation where my...

Hey Kothari,

Please be a bit more specific as to what your source, destination and transformation is.

Also, in your job history, expand and look at the detail for the specific job...

Hi Sabina,

One of the coolest free features that I came across was actually a removeduplicates transformation that ships with the Samples of SSIS.

You will need to read up on this,...

Wow.

Okey, thanks for the advice.

There were a couple of postings on when people deployed their respective packages to server and they didn't run, but so far in most cases it...

Call me pragmatic, but why can you not export the resultsets to a file with a normal dataflow task, stick a multikast in there, which aggregates and sends the count...

hey Venki,

Not that I have ever queried Lotus Notes DB (actually, first time that I heard that something like that exists....), but are you sure that you are querying the...

Awesome

Thanks for the tip

Hi Ed,

Quite a broad question indeed...

Firstly, coming from a third party ETL tool background (Datastage server as well as Datastage Parallel extender), I fail to understand how a third party...

This was quite an interesting question, as I also found that my MSDB folder was getting really cluttered, so I played around a little.

I wanted to group my stored packages...

If you read up on the Microsoft article, there are pros and cons to temporary tables as well as table variables.

Specifically:

Q5: Do I have to use table variables instead of...

Hi,

The closest you going to get is to probably specify your blank four rows excel workbook as source, and a different excel as destination.

When you define your source, then use...

Have you tried importing as csv and specifying that it should start at the 5th row?

If this option fails, you may consider adding a scripting task which removes the first...

Hi,

You would probably have to use an OLEDB source of your events table (assuming that your fact is an events fact), and then perform a lookup transformation against the other...