Phil,

As I am a new comer, can you please tell me what I need to do with respect to SSIS tool

It could be very helpful if you can give me...

Phil,

The additional columns will be filled by the client itself in the modified excel sheet with updated data manually.

The client will be updating the new columns in the excel sheet with updated columns. so the excel sheet will be always updated frequently and so shall be updated.

Main...

Hi Phil,

Exact Reqt is :

-Create a Contact table with the same structure/ columns mentioned in the excel dotnet_consumer_workbook_v_6_0

-Create Contact_Modified table with the following two additional columns (along with the existing...

Steve,

Ths reqt needs to be accomplished. URGENT

Requirement:

Whenever an excel template is updated with more columns, I also need to write a script so that excel template newly uodated...

Thanks Steve..

But I have much tough task ahead to complete first as soon as possible. Please helpme on this. Its on the same assignment

We have an excel sheet template as...

HI,

Even I have similar query...

We have an excel sheet template as table and we need to store structure in the database(SQL Server)

Reqt : I need to write a script so...

Thanks Steve, COuld you be much more descriptive?

You mean to say, i need to use transformations in order to validate data. If yes, which transformation.

As I have Date of Birth,...

Query Scenario:

1) First of all, for data import utility, the client can use dotnet application or legacy application

2) The data source type can be MS Access from which to import...

Hi Steve,

The excel sheet will contain the data of the client and the client will be updating on a daily basis.

Now, I need to identify and retrieve the primary column...

Thanks Steve,

Could you please guide me in getting the VBA script to get this job done. As a newbie, I am unaware of this VBA scripting and request your assistance

I...