Is it possible to post the configuration file? (replace sensitive info with dummy values)

You can use a script task that uses the DirectoryInfo.GetFiles(string) method. You can specify a pattern, such as *.csv. If one or more filenames are returned, the extension is present.

DirectoryInfo.GetFiles...

Everybody would like their answers ASAP.

Reporting-wise (SSRS), there hasn't much changed between 2008R2 and 2012. Some output formats got enhanced and SharePoint integration...

Thanks for the easy Friday question 🙂

Something like that yes. Not ideal, but the only thing I can think of right now.

Unfortunately, finding the exact error column is not that straight forward. It's possible though:

SSIS: How to get name of ErrorColumn from Error Output?[/url]

The solution will affect performance negatively.

First of all,...

shahgols (8/7/2012)

---

Hi all,

I've been researching the different options that we have in building our data warehouse. I am intrigued by CDC and the new CDC objects in SSIS, but...

A common scenario is to use a dataflow with the OLE DB Destination with the Fast Load option. Set the batch size smaller than the default, for example 50,000 rows....

Why 2005? The 2012 version is already out for a few months.

I know a couple of good books, but they are all for 2008.

Charmer (8/8/2012)

---

Hi Friends,

i am doing a project in SSIS 2008, SQL 2008R2...

In the data flow,

my source(OLEDB) has some duplicate records where i am removing the duplicate rows using SORT...

You can decrypt packages using dtutil, but this is is done when loading the package, so you'll need to copy it to some other place.

Good question. I took #3 and it was correct. I wonder what happens when you choose #1.

Nice question by...

Spent 15 minutes looking for the gotcha... (what do you want, after yesterday's question)

😀

tommyh (8/6/2012)

---

So here i was thinking this was a rewrite of the question we had 2 questions ago, since this question had the varchar(50) on str4 which would have fixed...

Very nice question Hugo, thanks.