Sandy,

Jeff point is important, my workstation has Office 2003 and 2010 installed, so the ACE driver was available, you may need to download the driver from Microsoft if you don't...

Hi Sandy,

Sorry for the late answer, there is a time difference, I was able to duplicate the error message you received

Error: 0xC0202009 at DFT Derived Column, Excel Source [1]: SSIS...

Ok, let's suggest some debugging:

a. Your Excel file location is a package's parameter; Does it have spaces? All my tests involved file names without 'spaces' and I always avoid them.

b....

Hi Sandy

You may try the following approach; create a package level variable, its name could be User::FileName; this is the variable that will contain your dynamic excel file, you may...

Hi Swathu9

These steps should help you to handle the invalid date field in your flat file; you need to add two components after your flat file source loading the text...

cafescott (6/15/2012)

---

Uh, never mind my last post. Rock, you rock yet again.

I didn't see it; but there was another variable named "Package_ID" in my list. I removed...

Hi CafeScott,

Did you check my previous post?, it seems you are having a variable scope issue, the behavior described sounds like you created the variable User::PackageID twice, the first time...

Well, I tried with a package level integer variable with a default 123 value, it worked, in both: the first script task and on the second ST inside a sequence...

Hi CafeScott

I did a quick test using Visual Basic (I work with C#), so it was very simple, I created 3 package level variables, User::TestVariable; User::WriteVariable and User::PackageID; assigned the...

The SSIS Problem Design Solution is a great book, I set its framework as a Visual Studio template, and it is a great idea to have one.

Based on the issues...

My approach was similar to the one described by Tim, here is a summay:

A control table tracking monthly records count for the most critical tables in the environment; this table...

the missing image.

Well, I don't like the folder structure you are implementing, but I am sure it was agreed to be done that way 🙂

This is a proposed solution, I tested it...

aarionsql (6/11/2012)

---

Hi All,

I have built a package which:

1. searches for flat files through a Folder structure on the test server

2. moves the files to an active folder

3. Then to...

THE-FHA (6/12/2012)

---

Hi guys this script displays duplicate machine name because it is possible that 1 machine may heve 20 patch levels installed. Now i dont want that, i want to...