Hi

I have solved this now, turn out the data had carriage retuens, tabs and line feeds in so have had to use something like..

SELECT REPLACE(REPLACE(REPLACE(REPLACE([error], CHAR(13), ''),...

Hi

yes, I am looping through a folder in the child package. The file path / name are variables with file name being *filename*.csv.

Currently there is only a single file (the...

Hi

 

Thanks for the reply. OK, so I have discovered a couple of things.

The RAW ETL did in fact complete and all other sources where imported. However, the SSIS catalog report...

Hi

Thanks for the replies, I ended up with a derived column which concatenated all fields into a single column (with my qualifiers), and union all'd with my header and footer.

🙂

 

Hi

the reason behind the dynamic query is I'm trying to create a pivot based on a start/end date but I want to create columns for dates where there are...

Hi

I know, i've tried converting everything to varchar(6) (even the principalid in the underlying table) and all i get is an empty recordset returned.

confused!

Hi

Just one thing, if you can help. How would i adjust the script to include a like statement instead of an =?

so, something like...
[code...

I thought I was avoiding injection by having an SSRS drop down but have now changed the query to your suggestions. 

January 22, 2019 at 4:34 am

#2019609

frederico_fonseca I can't call the stored proc to start an SSIS...

Thanks for these, unfortunately, they still don't give advice on how to pass a variable into an agent job? unless i'm missing something.

Thanks Andy, that worked a treat.
Final query is :

select ID, MeasureDate, Sector, sum(Amount) Amount from #TestData where Id in(1,2,3)
group by GROUPING SETS((ID, MeasureDate, Sector),(ID))

Hi

You're absolutely right, that wasn't a table. My bad! Expanding on your table (thanks) I used grouping sets to get the following....

select ID, MeasureDate,...

Hi

I've spoken to our outsourced IT support and they have come back with the following....

"I believe the NT SERVICE\SQLSERVERAGENT is a local account and therefore you cannot give it permissions...

aaarrggghhhh

ok, so i have managed to get it to run.

The package is deployed to SSISDB.

If i manually run the package it fails.

I discovered an option in Advanced tab which...

Hi

I've hit another wall. So i've now deployed the package to SQL 2012 (64 bit) but can't get it to run from management studio.

I'm running it under the sa account...