I was messing with this a bit i'm not sure you can use NULL in a parm. Seems a datetime type will default to min date after blanking out the...

• This reply was modified 5 years, 9 months ago by TangoVictor.

How are you assigning to a parameter? You mean updating it in the Catalog?

We use a similar process where at the end of an ETL we update a project level...

Cool, glad it's working.

As for the editor window, i doubt it, since that script unloads on each loop so there would be no reference to it.

I like to use message...

I'm curious how the string is formed when you combine those 2 values.

And still filePath value turns out to be \\\\xxx\\xxx\\Data\\xxx\\attachments\\somefile.txt

How do you know this is the actual value? Output...

just curious how the updates are being handled?

I know this is vague, i don't have a lot to go on, also didn't mention prior to moving these ETL's this server has been up and running for close...

I'm not sure i fully understand but you can modify the command line in the job for the dtexec call and provide a config file path but its not dynamic,...

I should have stayed out of this one, we are all on-prem so don't really have the feedback you're looking for. If looking for portability for the ETL jobs themselves...

Oh that does sound ugly and a cursor *looks around for Jeff* cursors aren't so bad 🙂

Yeah i feel your pain, i rarely look at or edit TSQL in the...

• This reply was modified 6 years, 2 months ago by TangoVictor.

I guess I'm focused on this statement:

a move to Talend would allow non-developer staff to handle integration task more easily due to it's drag and drop interface

I'm an experienced SSIS...

Totally agree, i mentioned it since they seemed to want to get away from the SQL tasks, but calling a sproc is minor.

I always tell the devs who are trying...

Was also going to suggest the calendar table as a way to expand dates. I have a similar process that i need to get a date range down to 1...

from what you are saying it seems the main issue is the unpivoting of the data.

Here is a post about using the unpivot component. This may help get you started.

Thanks Steve, sorry i just saw query store and assumed, i'll check it out.

Steve, this is running 2012 but when we get it moved, yeah query store for sure.