Thanks for sharing 🙂

I agree with you that this is a pain as I have been through it. My packages were also running fine for months. and then this error came:crazy:

I renamed only...

xp_fixeddrives

If you don't want to use xp_cmdshell then

1. Create a job with step of Type Operating system (CmdExec) and type you sqlcmd command in that.

2. Then from the stored proc...

http://msdn.microsoft.com/en-us/library/bb522537.aspx

You can not use derived column names in the WHERE clause.

Try following query:

SELECT Vw_Final_Inventory_Report_1.*

,(sum(Dqtyin) - sum(Dqtyout)) AS ClosingBalance

FROM Vw_Final_Inventory_Report_1 vw

INNER JOIN Tb_Item_Cost_Ledger tb

ON tb.itemid = vw.Vw_Final_Inventory_Report_1.coa_id

WHERE VDate <...

Use the SQL server Profiler. In SSMS -> Tools menu -> SQL Server Profiler.

You can delete inside the DFT using the Data flow transformation task "OLE DB Command". But I would suggest you to delete before entering into the Data Flow Task...

I don't have 2000 box to test.

but I think it won't work in SQL server 2000 as in 2000 you must pass a constant expression to a table valued...

Which SQL version are you using?

chandrashekar.2512 (11/20/2009)

---

Thank you Vikas,

When i execute your function i got this error,May i know why this error i am getting

Server: Msg 155, Level 15, State 1, Line 15

'catid' is not...

Create this handy function:

ALTER FUNCTION [dbo].[fnSplit](

@InputString varchar(8000)

,@Delimiter varchar(10)

)

RETURNS @TempTable table(

ID int identity(1,1)

,[VALUES] varchar(8000)

)

AS...

I follow these steps in scenario that you explained:

1. TRUNCATE the table before the data flow task

2. Load the table with Table - fast load option.

Bu it depends on:

1....

Renaming the package worked, it is executing perfectly now.:cool:

I don't believe it but it is working.

Hi llitvin,

I ran the package for 7 days in a loop yesterday and it worked fine. But it is giving pain when I ran it today. :crazy::(

It can not be...