Thank you for your reply, but I would like to retain a copy of the original excel output...

Changing the mapping to the UNC path resolved my issue. Thanks for the insight and my apologies for the delayed response.

happyCat59, thanks for replying. I will look into your advise and reply back with my outcome.

John Mitchell-245523 (10/19/2015)

---

It'll be your WHERE clause. If you have any non-numeric values in any of those four columns, you'll get the error. Try this instead for each...

Thanks for the insight. However, I'm getting the following error message below:

Msg 156, Level 15, State 1, Line 22

Incorrect syntax near the keyword 'From'.

Msg 156, Level 15, State 1, Line...

Luis Cazares (4/7/2015)

---

The "DDL" is not good as we can't use it.

Some questions:

Why are you concatenating values instead of parametrizing your queries?

Are you aware of SQL injection?

Why are you using...

Here's a sample of the data from the temp table:

"into #tbl_claims"

ClaimNumber R1 ...

Added it.

Thank you, this worked for me.

Jeff Moden (1/19/2015)

---

Briceston (1/19/2015)

---

I'm using GetDate() in T-SQL. Below is the where portion of my script, which returns no data, there should be data for...

The destination will be in Excel. My problem is not with SSIS, my issues is what's the correct GetDate() and Dateadd syntax to use?

I'm using GetDate() in T-SQL. Below is the where portion of my script, which returns no data, there should be data for the intended dates.

WHERE [register _date ] BETWEEN...

I'm encountering the below errors when I run my package. I have tried switching to 32 bit as per some resolves on the internet, but to no avail, and have...

I got the package to work after hours of investigating it. Turns out one of my variables did not have the complete file path. Also, my outer Foreachloop Container was...

Running the package via a job returns the same outcome as before. My problem is with the ForEach Loop Container. The package starts the validation phase and then cancels.

SSIS package...

Yes, my packages are ran by hand or automated via job through sql agent.