I think you mean to say that you want one variable to hold three values... and pass this to one method on the web service.

You can pass the values...

Where do you see the identity property for a column? I did not see it under sp_columns.

It would help if you presented a representation of your recordset ... what you have... and what you want the final output to look like. As I see it you...

Start by right clicking the detail row and select to add a parent group. In the popup dialogue you select the column to group by and if you want to...

Note that in your dataflow, click the green arrow and see that you can add a data watcher. You'll see the data as it flows from the source and BEFORE...

Very awesome. I'll try it out, Thanks!

Else, I found out the ssis package first import the data into a table that has raw data, meaning no constraints defined, then import from raw table to the real...

You have to touch everything that depends on that data stream so that it knows what to do with that new column.

SSIS has an XML source and XML task. THe XML task can validate your data, merge it with another xml set and even do comparisons between the sets (You would...

Hi,

What provider did you use when creating your link?

Not sure if this is still an issue for you... other options are using the fast load option in a OLE DB destination. Not sure if there are constraints on...

I would be interested in seeing the solution.

Wouldn't "SELECT CURRENT_USER, ORIGINAL_LOGIN(), SESSION_USER, USER, USER_NAME(), SYSTEM_USER" return the general user account ? If this is a scheduled job created...

You would need a helper dataset query that went something like :IF (@client=1)

begin

select @datefrom = dateadd(m, -6, getdate() )

You pass the results to the master dataset ...

My advise here is to build a more general stored procedure that brings in all the columns you need at a granular (lowest common factor) level. I assume you mean...

Was this message the result of a server trigger, has this been ruled out? To remove permissions, one would employ the REVOKE command.