Hi There,

I used 'Execute Process Task ' in SSIS to call a VB Script that I had written.I also have used Execute Process task to call a third party vendor...

Damon:Thank You , Im already planning to purchase at least 1 book to start up with.

SSH: All the Best for the exam .

...

Thank You all,....I tought it was the same account as well....

SSH: How's the preparation going ?..

I'm juggling between work and study......

...

wpotter (2/27/2008)

---

I am trying to set up a start date and an end date for the report so this report can run monthly on the first business day after the...

I had a problem similar to yours, order of my Input columns[in table] did not match the order of my Output columns[ in TXT file].

If this sound fimilar to your...

Hmmm..pretty tedious process Mate...

I came across this today

http://weblogs.sqlteam.com/jamesn/archive/2008/02/13/60509.aspx

Planning to give it a try and see how it works out for me.:ermm:

Peso,

Im the one who logged that topic on SQLTeam as well.I currently have got the INSERT part working with some help.Currently working on Update.

I know it is a very unreasonable...

Hi Chris,

I totally get you, but my employer is just over the hill to use a dynamic stored procedure.If only I can get this working, as I have a strict...

Hi Guys, I was busy still trying to figure out how to make this work.

I have no choice but to use stored proedure, as my boss is insisting on using...

Hi There,

I have no choice but to use the stored procedure as my company is not wiling to spend the big bucks.Hope you can provide me with some suggestions...

Ok, I have tried the following

Create PROCEDURE CompareTables

(@table1 varchar(100),

@table2 Varchar(100),

@T1PK varchar(50), --Primary Key

@T2PK varchar(50), --Primary Key

@T1ColumnList varchar(1000),

@T2ColumnList varchar(1000) = '')

AS

declare @SQL varchar(8000);

declare @SQL1 varchar(8000);

declare @SQL2 varchar(8000);

IF...

In Visual Studio

File > Save Copy of Package.dtsx as > Select SSIS Package Store as Location > Define Server and for Package Path[Click on button [.]] and now pick the...

Steps to Follow ...

1) Create 4 tables a) Table_A_Duplicate_Records b) Duplicate_Records

c) Unique_Records d)Invalid_Records[i]records with selection columns having all NULL values[/i]

2)Insert into Table_A_Duplicate_Records, all records from Table_A[original table]that has more than...

Man...you have lots of data....:w00t:Anyways let me get this right, you need to remove duplicate rows based on Cust-id,f-name,l-name & email add.So only 1 transformation currently involved from [Source >...

Hi there,

We had a conference call with someone from the SQL Server Escalation Support group two days ago on the issue of Fuzzy Grouping performance, we have been struggling with...