I was wondering how I'd go about logging the actually SQL sent to the server. Ideally I'd like to know how to do this at the SSIS end (outbound) and SQL Server end (inbound). Thanks in advance! Adam

Thanks for the tip! Sincerely, Adam

You can use SQL Profiler to track what commands are executed on the server.James Beresford @ www.bimonkey.com SSIS / MSBI Consultant in Sydney, Australia SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex

James is correct ... you have to use SQL profiler for this OR If you are creating the new SSIS package then you can also do the custom logging in your package where you can save all the SQL commands.Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Ok, I've been looking for a couple of hours, how to do trace INSERT/UPDATE statements sent from SSIS via OLEDB *rubs chin* Thanks in advance! Sincerely, Adam

I've not been able to see what switch to enable so I can get the actual SQL statement, I see the INSERT statement I'm after, but not the parameter values sent ---snip--- <Column id="1" name="TextData">insert bulk [dbo].[tmpupd_ols_recipients_staging]([Name_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[ObjectType_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[DirSyncID_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[AccountDisabled_T] bit,[AccountHidden_T] bit,[Alias_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[AltEmailAddress_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[City_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[Company_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[CountryorRegion_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[CustomAttribute1_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[CustomAttribute2_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[CustomAttribute3_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[CustomAttribute4_T] nvarchar(255) collate SQL_Latin1_General_CP1_CI_AS,[CustomAttribute5_T] nvarchar(255) ---snip--- I really want ---snip--- INSERT INTO THE_TABLE ("NAME", "OBJECTTYPE", "ACCOUNTDISABLED", "ACCOUNTHIDDEN", "ALIAS", "ALTEMAILADDRESS", "CITY", "COMPANY", "COUNTRYORREGION", "CUSTOMATTRIBUTE1", "CUSTOMATTRIBUTE2", "CUSTOMATTRIBUTE3", "CUSTOMATTRIBUTE4", "CUSTOMATTRIBUTE5", "CUSTOMATTRIBUTE6", "CUSTOMATTRIBUTE7", "CUSTOMATTRIBUTE8", "CUSTOMATTRIBUTE9", "CUSTOMATTRIBUTE10", "CUSTOMATTRIBUTE11", "CUSTOMATTRIBUTE12", "CUSTOMATTRIBUTE13", "CUSTOMATTRIBUTE14", "CUSTOMATTRIBUTE15", "DEPARTMENT", "DISPLAYNAME", "EMAILADDRESS", "EMAILADDRESS2", "EMAILADDRESS3", "EMAILADDRESS4", "EMAILADDRESS5", "FAX", "FIRSTNAME", "HOMEPHONE", "INITIALS", "LASTNAME", "MOBILEPHONE", "NOTES", "OFFICE", "OTHERHOMEPHONE", "OTHERTELEPHONE", "PAGER", "PHONE", "POSTALCODE", "PASSWORD", "STATEORPROVINCE", "STREETADDRESS", "TELEPHONEASSISTANT", "TITLE", "WEBPAGE", "TENANTID", "LASTMODIFIED", "SITEID", "FLAG") VALUES (1300903798659, 'Mailbox', '0', '1', '1300903798659', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1300903798659@abc.com', '1300903798659@abc.com', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1password2', '', '', '', '', '', 'abc.com', '', '', 'Y') ---snip--- Sincerely, Adam