niall5098 (10/7/2016)

---

HI There,

as the heading suggests I am trying to query a text based audit for specific values then compare them values. For example the column should contain and new_ref_no...

Jeffery Williams (10/6/2016)

---

I will give it a try thank you. AND I don't have to count I just need to know if the result is greater than 0. Basically...

You have been here long enough to realise that this is...

Read the text files, check the errorlog,...

Lynn Pettis (10/6/2016)

---

If you are accessing the tables on the linked server and doing all the work on the local server, you are pulling all the data across the network...

Ed Wagner (10/6/2016)

---

Yeah, that's a good one. Be...

Eric M Russell (10/6/2016)

---

Jeff Moden (10/5/2016)

---

komal145 (10/5/2016)

---

i have check other tables and do lot of stuff to get this point . So , i have to do it in ssis....

The sensitive values cannot be retrieved, unless the user who originally saved the project opens it again.

Redgate SQL Prompt and SSMSBoost both save a history of queries.

Why are you doing this, out of interest?

SQL-DBA-01 (10/6/2016)

---

Hi Phil,

While deploying getting the below Warning. But able to deploy the packages successfully. No error.

Is there something to look into against this warning?

TITLE: SQL Server Integration Services

------------------------------

Warning:...

SQL-DBA-01 (10/6/2016)

---

Hi Phil,

It worked...:) I am able to import/deploy the .ispac packages. Thanks much.

If I need any further help from you on this will let you know.

Thanks much for your...

And good luck handling Excel's semi-random data-type guesswork 🙂

Sure. Skip the header rows by setting 'Data Access Mode' to 'Table name or view name variable'.

Set the variable's value to a range which excludes header rows, eg:

sheet1$A2:D

which...

Yes. Create first, then folder structure and finally deploy.