Search results for query: *

I am using Visual Studio 2008 and building an SSIS package that uses the "SendMail Task". I am dynamically building the MessageSource from variables being passed in from an SQL task. Below is my current string, but I am trying to figure out how to insert "New Lines" in the statement...

I got it - Thanks for all the help!!! Ad.

Thanks for the help - I am still not clear on where and how you assign assign the data from the SQL Task Pull into the variables? Here is what I have done - I built and SQL Task to pull in all the data I need and set it to a FullResultSet and setup the ResultSet Name as 0 and assigned it to the...

have a table in SQL that gets updated inside another SSIS package. I am trying to figure out a way to be albe within an SSIS package to parse through the table which contains a flag field of "yes" or "no", other data and a field with an email address in it. I want to parse through the data and...

I having troubles with the different seperators in this one and just picking out the lines I want keyed from the .dat filename. I basically have an autogenerated flat file that is an export of a directory structure. I want to parse through the flat file and pull values from specific lines that...

I need some assistance with reg/exp in regards to splitting up a string and putting items from it into variables I have a flat file that as lines and lines of data that follow the same pattern throught and I am writing a routine to pull out data elements from each line and insert them into a...

I have two tables in access - In the primary table when a record is created I want to automatically use the primary key from this table and search for that key in another table. If found I want to "Clear" that value from the secondary table and leave it blank. How would I do this? SQL, VB...