Hanging on Execute SQL Task that returns a single row result but fails

If an Execute SQL task fails when returning a single row result (no rows returned to be loaded into the variables), it appears that DTLoggedExec never finishes, and just hangs. I ran a Package.Exec...

Id #35536 | Release: None | Updated: Sep 15 at 6:23 PM by NWest | Created: Sep 10 at 2:19 PM by NWest

is this working for 2012?

Hi Is this working same as Sql server 2012 ? I tried but it's give me error like as below OnError: Package Name: Object Type: () Description: Object ID: Container...

Id #34070 | Release: None | Updated: May 20, 2013 at 6:39 AM by shrey_halani | Created: May 20, 2013 at 6:38 AM by shrey_halani

Slow start from SQL Agent

If you run DTLoggedExec from a SQL Job you could have 30s delay per step depending on your network configuration. It not seems related to the executable itself, but to the CRL Certificate Revocati...

Id #33751 | Release: None | Updated: Feb 14, 2013 at 2:35 AM by miken175 | Created: Feb 9, 2013 at 9:36 AM by miken175

Dataflowprofiler not logging anything when SSIS packaged only was "Execute SQL" Tasks

I running a statement like this "C:\DTLoggedExec\X64\DTLoggedExec.exe" /SQL:"\SERVER\SSIS_package_ETL_load" /Server:"SERVER" /LE:E,I,PRE,POE /PDFN:"C:\DTLoggedExec\DataFlowProfile{filename}_{date}_...

Id #31454 | Release: None | Updated: Feb 14, 2013 at 2:35 AM by Spurt | Created: Sep 14, 2011 at 1:55 PM by Spurt

Set Parameter value error when string has ';'

Hi, If you are setting a string value that has a semicolon in it. The args parsing will fail. To fix this change the following line in the following method DTloggedExec.Program.cs   private static ...

Id #29408 | Release: None | Updated: Feb 14, 2013 at 2:35 AM by oszymczak | Created: Nov 12, 2010 at 1:37 AM by oszymczak

/CONNECTION parameter?

dtexec has some more parameters. I use the /CONNECTION (or /Connection) parameter frequently to run the same packages against different connections, but it is unrecognized by DTLoggedExec. Is there...

Id #29374 | Release: None | Updated: Feb 14, 2013 at 2:35 AM by manowar | Created: Nov 7, 2010 at 1:57 PM by Germo

FileSystemTask (Move) not working inside event handler

I created a package that would process files in a certain directory using for each loop container. Then I've created an event handler on the FELC in case there's an error, it has one File System Ta...

Id #27695 | Release: None | Updated: Feb 14, 2013 at 2:35 AM by raclede | Created: Jun 18, 2010 at 9:05 AM by raclede

; missing in import-profile-data.sql

I'm investigating this for use in our company and I ran into a missing ; in the import-profile-data.sql script. SQL gave an error when I ran the batch file saying "Incorrect syntax near the keywor...

Id #26479 | Release: 1.0.0.1 | Updated: Jun 14, 2013 at 6:58 AM by manowar | Created: Mar 15, 2010 at 1:48 PM by JeanPaulSmit

Events switches seem to alter the behaviour

SQL Server 9.0.4035 Standard DTLoggedExec 0.2.3.0 I'm facing a weird behaviour with a script task, but I feel it's bound to db connections which are altered using expressions...   EDIT: I reach the...

Id #25738 | Release: 1.0.0.1 | Updated: Jun 14, 2013 at 6:58 AM by manowar | Created: Dec 21, 2009 at 1:24 PM by PGFIORE

Exception when logging the POV & PRV events

Version: 0.2.3.0 The use of the POV and PRV switches fires an exception.   I tried with a fully empty package (no tasks) with neither loggging nor package configuration. The package only contains a...

Id #25737 | Release: 1.0.0.1 | Updated: Jun 14, 2013 at 6:58 AM by manowar | Created: Dec 21, 2009 at 12:13 PM by PGFIORE