wafw1971 (2/6/2013)

---

thanks for the quick replies, because I am learning I have decided to just populate the first column with a date say 01/01/2010 and then increase this in increments...

Jason-299789 (2/6/2013)

---

(reposted from other thread)

Your best bet is to use a TALLY table, a CTE, or at worst a Recursive CTE.

using an crude tally table

With Cte_n

AS

(

Select 1 a Union...

aaron.reese (2/6/2013)

---

Resolved but not happy:angry:

from the command line I have to use the /conf[iguration] switch to specify the location of the config file which will then override the location specified...

fecker (2/6/2013)

---

First: thanks for your feedback. Description may be strange while I am german.

I did some screenshots (attached) - for this dummy - maybe this will explain more. I run

this...

iamsql1 (2/5/2013)

---

HI

i have a qs: if i have a data flow task inside for loop container. and DFT contains five static connections of FLAt file as Source...

The SQL Agent job runs asynchronously - so it's not going to return 'finished' info to your application.

You could, perhaps, implement an MSMQ solution, though that may be a sledgehammer...

I tried understanding what you are trying to do, but it confused me as it's not written very clearly.

But then you have said that your script task to update a...

opc.three (2/5/2013)

---

The issue is that...

aaron.reese (2/4/2013)

---

Thanks Phil, That was a useful lesson.

Unfortunately I can't see how to assign the value to a variable without using a script. I have tried sending the...

Read the file in a dataflow.

Add a conditional split which redirects processing according to what has been read - two outputs: Build Success and the rest.

Each different path sets a...

iamsql1 (2/4/2013)

---

Hi Phill

I am newbie to SSIS, i tried every effort to change the variable in olde db...

iamsql1 (2/4/2013)

---

HI

i have an idea. can i use a stored procedure and get it executed in EXECUTE SQL TASK

instead...

Not in this forum! 😉

Anyone else picturing a man with a big hammer? 🙂

Excel 2003 has a maximum number of rows of 65,535 - maybe that is the cause of your error.

Try exporting to CSV instead to see whether that is the reason.