This is solved.

Hi,

After going through so much, the main problem was with the Flat File Destination task. It was getting the file from one of the drive (F:\\). Internally, it was working...

Ok, i installed IS with the WorkStations. The package now runs fine from the Integration Services. Before, this was errored out.

Now, when I try to run this package from the...

I installed the Sql Server 2005 Developer Edition 64-bit. All i installed was the Work Station Components, Books online and Development tools. Do i need to check the Integration Services...

Hi,

I did find one thing when i ran the package from the integration services. Here, I can see the detailed error message..should have done this earlier.

Error: The product level is...

Hi,

I changed the protection level of the package in BIDS as EncryptSensitivewithPassword. Upon saving the package, it asked me to enter a new password. When I imported this package in...

Yes, when i execute this package from the agent, then after 4 seconds, it stops with with the error message i provided above. Thats the error message i get when...

Here is what i ended up doing.

Since there would atleast one file uploaded everyday, before i call my routine, i have another package that wipes out the files from this...

Hi Phil,

Thanks for the reply. But this folder has files from every day, so there would be a lot. How would i rename the particular file that i want?

Hi Grant,

Will it be good to join back to the file using Address info? Sometime, the address could be the same for 2 dealers.

I tried adding a variable to hold...

Hi,

Thanks for your reply. I tired using OUTPUT clause but not sure how to get the DealerId. Below is my query.

CREATE TABLE #tAddress

(

AddressId INT IDENTITY(1,1),

AddressId varchar(255),

City varchar(255),

StateId int,

PostalCode varchar(50),

CountryId int

)

DECLARE...

Table structure:

CREATE TABLE [dbo].[Customers_monthly](

[Intuitive] [nvarchar](5) NULL,

[Intuitive Cust ID] [nvarchar](255) NULL,

[Solomons] [nvarchar](5) NULL,

[Solomons Cust ID] [nvarchar](255) NULL,

[COMPANY] [nvarchar](255) NULL,

[Contact Title] [nvarchar](255) NULL,

[Salutation] [nvarchar](255) NULL,

[First Name] [nvarchar](255) NULL,

[Last Name] [nvarchar](255) NULL,

[Gender] [nvarchar](255)...

I have tweaked my query and now it works. I am sorry if this has become redundant. Also, could you point out if I am allowing sql injection anywhere on...

Never mind...i changed the INNER JOIN to BillingHistory to LEFT JOIN..it seems like there were no match..but now its working. I will check the data but this is great stuff....

Hey Lowell,

I don't get any result when I run this view.

WITH cte AS

(

SELECT c.ClientCenterId AS DealerNo,

...