You can first import your data into an SQL staging table. Then run an update statement to...

mayank.singla (4/28/2011)

---

Hi,

I am facing issues while deploying CLR Stored procedure. I am not getting any message in error list or in output window but an error box saying "There were...

mayank.singla (4/28/2011)

---

Hi,

I am facing issues while deploying CLR Stored procedure. I am not getting any message in error list or in output window but an error box saying "There were...

avadhut.joshi 17339 (4/28/2011)

---

if I do it then only 75% of my containers run properly last two containers dont get run..so is there any issue with that..am I doing any mistake...

Did you set the 'RetainSameConnection' property to True on your connection (from the connection manager)?

avadhut.joshi 17339 (4/28/2011)

---

Hi

I am finding following error for transaction.

Error: 0xC002F210 at CommitTransaction1, Execute SQL Task: Executing the query "Commit Transaction BeginTransaction1" failed with the following error: "The COMMIT...

sashikanta.mishra (4/28/2011)

---

Hi Gail,

Thanks for the same.

Even our team is working on for SQL 2005 and 2008. So, it will be helpful if somebody can tell me how monitor the...

sivaprasadyellala (4/27/2011)

---

SSIS guru's,

I am running a delete statement in Execute SQL task passing a...

kiruthika.naren (4/27/2011)

---

my text file is not in formatted way. see below example.

R001D0345003214555 Ambika, Mahesh A

in the above sample,

R001 - region

D0345 - district

003214555 Ambika, Mahesh A - employee cde...

BackT0Work (4/26/2011)

---

I have a stored procedure

create procedure ErrorMail_sp

@JobName varchar(50),

@TableName varchar(50),

@Issue varchar(MAX)

AS

BEGIN

declare @desc varchar(MAX)

set @desc= ' Job Name : ' + @JobName + ' Table Name : '+ @TableName+ ' Issue...

Sri8143 (4/25/2011)

---

I am trying to export a table to flat file using Pipe Delimited(Doesnt matter if its other delimited also).

There is a column which has datatype varchar(512) when exported...

BackT0Work (4/19/2011)

---

my SSIS package loads data from excel file to SQL server table. The excel file has 5000 rows.

When I execute the Package the number of rows shown in the...

Hello

Never tried this but maybe you can check if an INSERT/UPDATE trigger on the sysssislog table will do the job for you?

Also, maybe at the end of your package, you...

rmkmurali (4/20/2011)

---

[font="Tahoma"]

Hello Friends,

I was going through several blogs and found a way to log the package run details to a user defined table. Following is the code for the same.

CREATE...

When you remove...