here:

CREATE TABLE [dbo].[CUSTOMER](

[CUST_ID] [numeric](31, 0) NOT NULL,

[CUST_TYP_CD] [varchar](15) NOT NULL,

[CNTRY_ID] [numeric](31, 0) NULL,

[CUST_NO] [varchar](30) NULL,

[CNTIRT_CD] [varchar](15) NULL,

[CRST_CD] [varchar](15) NULL,

[CUST_SGNTR_FILE_NM] [varchar](80) NULL,

[AUDIT_USER_ID_CREA] [numeric](31, 0) NULL,

[AUDIT_USER_CREA_DTM] [datetime] NOT NULL,

[AUDIT_USER_ID_UPDT] [numeric](31, 0) NULL,

[AUDIT_USER_UPDT_DTM]...

1- simple select query to extract the data from source and insert into destination table.

2- the query should run first time and load all the data from the source.

3- query...

Data runs on a daily basis from different processes which insert the data into the table.Yes, it runs every morning as schedule. once it is insert into this table the...

There is other process that just insert data to this table where 'Sent' column is '0' when other process insert data to the table. Then from their I have to...

I tried DATEADD(mm,0,Getdate()) also and the current month but didn't get the previous month. Need previous months and current together.

@CurrentDate in the procedure is as a parameter and Set to NULL. So in the SSRS report the user will not enter the date. Only input the other information and...

I want to skip or ignore the rows that are coming from the source file. I have created SSIS package and I was pulling the data from a .csv file...

Craig,

Thanks for the info. I want to one more time explain the problem just to make sure that the statement u mentioned is write. So I have a source flat...

I want to know from T-SQL(store proc) in a staging table and also SSIS.

OK. You its right if I use this statement to delete this it will delete it. The whole purpose is that I want the last row to be deleted where...

I mean my question is that a table have some columns and at the row there is a grand total of a data in the above column. So, if i...

Distinct does not work but Top 1 works. I only change TOP 1 in the first 2 SET statements and it works, third and fourth statements i didn't change anything.

thanks.

I tried using before but didn't work.can u tell me how to use the distinct to replace SET statement.what fields needs to be distinct?

thanks.

I think I actually found out which part of the code is giving the error. It is on the first two SET statements when I pass the three variables @Project_Id,...

The code I posted in my first post is in SQL Exexute Task from a SSIS package.