Reputation
6,451
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 19 47
Newest
 Constituent
Impact
~415k people reached

Aug
31
comment dtsinstall.exe does not deploy packages
Look at the contents of the manifest - does it have the package listed in it?
Aug
31
answered dtsinstall.exe does not deploy packages
Aug
26
answered SSIS compatibility
Aug
19
comment SSIS Package Error when called from SQL Agent Job
What version of SQL Server is on the SSIS server and the server running SQL Agent? Do you have more than one version of SSIS installed on either server? What does your job definition look like? If you log in as the service account on the SSIS server and run the packages (via command line) - do they work? If so, log on to the Agent server and run the packages (via command line)
Aug
18
comment How to extract pipe-delimited data using BCP?
Is BCP the only acceptable means of generating your output or would you accept other tools that will be available on your server?
Aug
17
comment Update source table from SSIS after Inserting in Destination
SSIS Package -> Data Flow Task -> OLE DB Source Component. Double click. Change the Source from "Table or View name" to Query. UPDATE X SET Sent = CAST(1 AS bit) OUTPUT DELETED.* FROM dbo.Notifications AS X WHERE X.Sent = CAST(0 AS bit)
Aug
17
comment Update source table from SSIS after Inserting in Destination
Perfect! In the linked duplicate, look at the approach I use with the OUTPUT clause. That is what you want to do. Begin your transaction, mark everything as Sent = 1 and push the DELETED virtual table into the data flow. That will all get pushed to the target table. If something "bad" happens, the transaction can be rolled back - no harm, no foul
Aug
17
comment Update source table from SSIS after Inserting in Destination
Is the notifications table in App1 SQL Server 2005+?
Aug
17
comment SSIS Package Error when called from SQL Agent Job
Error codes in SSIS rarely provide value. The text of the errors is usually much more enlightening. It is unusual for only a single Error event to be raised. Generally, I see three Errors every time an error occurs in an SSIS package. One of them usually has information we can make sense of. What's provided is not one of those cases. "An OLE DB error has occurred" Ok. Is it a bad query for supplied parameters? Is it permissions? Is the server unavailable?
Aug
13
answered Is it possible to develop a SSIS with a SQL Server Evaluation Version
Aug
10
awarded  Constituent
Aug
6
comment Is there any way to set the default data source for the SQL Server Import and Export Wizard?
I thought that was driven by whether you select Import Data or Export Data from the SSMS context window but SSMS 2014 at least is proving me a liar. I could have sworn that an earlier version (2005/2008) at least would set the context for the first or second screen based on whether you were importing or exporting into the given catalog.
Aug
6
answered Why would a job call a batch file with dtexec.exe instead of just calling the SSIS package directly?
Aug
5
comment How can I learn more about how SQL Server “normalizes” queries prior to creating the execution plan?
@ypercube "All drains lead to the Ocean"
Aug
3
comment Create an AD user from a SQL Server trigger
Service Pack 4 is available for SQL Server 2008. You should patch your SP3 instance in addition to the fine advice from marc_s and mike fal
Aug
3
comment Could not load file or Assembliy “SecureBlackBox.dll”
You need to register the assembly in the global assembly cache. The typical tool for doing so is gacutil which you indicate does not exist on the server. Best I can think of is to open a command prompt (Start -> Run cmd.exe) and type cd ` and then dir /s /b gacutil.exe` and hope that there's one hiding somewhere in a frameworks folder
Jul
30
answered When does SSIS SQL Server Configuration write to the configuration table?
Jul
30
comment Is an SQL Server trace 'considered harmful' in production?
"You won't run a trace? That's fine. So, the users are waiting for the queries to complete so they perform their jobs. What alternative do you propose to identify the hotspots? " They may come back and say XE but I've often found that in larger organizations, it's the monkey banana spray scenario - someone set a rule once and no one left knows why the rule is there but it's the rule
Jul
30
reviewed Approve MySQL data transfer to different schema
Jul
29
comment How to capture PRINT statements from TSQL called by CLR stored procedure
PowerShell version sqlskills.com/blogs/jonathan/… SO answer stackoverflow.com/q/1880471/181965