Thanks for the help. Was able to get 99% of the data extract to work. There is a problem with only 1 field in this table. The field is OleObjects...

As a further follow-up and question:

When using the QUOTENAME script to pull/extract data from table (example script below) I had the following issues:

5 fields that had Null values for...

Thanks for your response. I have fixed and posted the test data below. Also attached a text file with the same.

I am still unclear on the structure and how to...

Per Lynn's quoted reply below. Being new to SQL (my background was some light VB programming) I am unclear by what is meant by a set based solution. Most of...

Per your post below, what is the advantage doing the inner joins versus the code I wrote? I have been only doing T-SQL for a short time and appreciate any...

Can a trigger call or run a stored procedure?

Can a trigger call or run a stored procedure and then return back to the same trigger for futher processing?

The formatting of my example in the previous post did not work correctly. Attached is Word document with the correct formatting for better readability.

Further Clarification and Data File attachment.

Using SQL Server 2005 in 64 bit environment.

Have 2 tables CON_tblContact (table 1) and QVIContactActivity (table 2).

Trying to create a trigger so that when...

Screen print of quotename code and the incorrect results (in text output).

Attempting to follow the Form Etiquette guide as posted. Using the QuoteName example however I have Nulls in many fields and the text output only shows one column "NULL" with...

Previous reply:

1) Include a SQL Script Task in the control-flow, probably before your data-flow task runs.

I know that there are 2 panes in BIDS that display the different flows...

I will try the last suggestion of editing the flat file connector and modifying the delimiter and text qualifier settings.

In the meantime, I have a couple of other questions:

1) How...

Tried several different methods and found out that part of the problem was using the Microsoft Excel (driver) as the data source. I switched to using the Flat File data...

Still having issues.

1) Open Visual Studio/BIDS and open project. Open Data Flow tab and right click on Source-Sheet1$ object

2) Click on Show Advanced Editor

3) Select Input and Output Properties

4)...

dmc (9/11/2009)

---

Look at the data type for the SSIS component (source output) to see the data type. If you just used the default it probably read the xls data...