Recent content by putts

Figured out my own problem. In my package, I have the scenario that I had portrayed....Data Flow to create Flat File followed by an FTP Task to upload the file. However, I was doing for 2 tables so I actually had 2 copies of that sequence. The FTP Tasks were running close to the same time and...

Edit on my response.....ignore the first 2 dim statements.....they are already in the code later on.

Another alternative is to use a Script Task. Store off the value of your COUNT from your Execute SQL Task into a variable. Create a Script Task. On the Script tab, type in your variable's name into the ReadOnlyVariables line. Click Design Script. Type in something like this.... Dim startInfo As...

What I have.... A Data Flow task that Exports data from the database to a flat file. An FTP task immediately following that Data Flow Task that then FTPs that File to an FTP Server. I can get the process to work if I do an Execute Task on each one individually but if I just try to run the...

I have a script with a bunch of statements and one of them is this..... DELETE FROM TEMP_FII A WHERE WS_INSTANCE_ID IN (SELECT WS_INSTANCE_ID FROM TEMP_FII WHERE A.ID <> ID) Clearly, what I'm trying to do here is insure that there WS_INSTANCE_ID is distinct within this table and I'm using that...

Thank you, Marc.....that was it! UPDATE FI_SUM_WF_AGENT_REL SET (FI_AGY_CD,FI_POL_ID,FI_NAME,FI_STATUS,FI_WF_STOP,FI_WF_INSTANCE_ID) = (select DISTINCT CL_AGY_CD,AF_TITLE, CASE WHEN CL_DBA_NM_SRCH IS NOT NULL THEN CL_DBA_NM_SRCH ELSE CONCAT(CONCAT(CL_LAST_NM_SRCH,', '),CL_FIRST_NM_SRCH)...

I'm guessing these aren't allowed. The following is my example.... UPDATE FI_SUM_WF_AGENT_REL SET FI_AGY_CD = CL_AGY_CD, FI_POL_ID = AF_TITLE, FI_NAME = HOLDER_NAME,FI_STATUS = STATUS_DESC,FI_WF_STOP = WST_STOP_TS FROM select DISTINCT CL_AGY_CD,,AF_TITLE, CASE WHEN CL_DBA_NM_SRCH IS NOT...

I have a Join query that is hitting a table with about 4 million records and about two others that about 1.5 million each. The query used to run fine but lately is beginning to really creep (about 13 minutes for 50000 records returned). I started looking around Control Center hoping to trip...

First off, thanks for the replies. slight bummer, though, because I typically build my reports with almost no parameters in them that limit the data and then I have this ultra-dynamic-database-table-driven that eventually builds up a RSF for the report and then sends that in on the fly. The...

How do you build a record Selection Formula that does something like a sub query. For instance, let's say we have an Invoice database and one of the items on the invoice is the salesperson. In my report, I want to pull any invoice that has Bob as the salesperson. Trick is, there could be...

Just for prosperity's sake, Naith's Underlay Following Section works perfectly for this situation (as long as it's in the Detail, I suppose) I was having the same problem..... - Have a subreport populating some variables - Needed some field in my detail based off those variables - If I put the...

Okay, here's the situation. We have an outside company do some stuff for us and they have a working copy of some of our databases however they use different naming techniques than we do for the actual MS SQL Database names. So, they made a report for us that pointed to an ODBC connection that...

IdoMillet, Question for you. I was unable to find it in your user manual but did you say that using your third party software this could be done. We have a job that runs (VB6) that's an EXE that prints out this report that is several several pages long. For the most part, it goes...

Solved: Set DatabaseTableCol = session(&quot;oRpt&quot;).Database.Tables for i=lbound(arrSort) to ubound(arrSort) if arrSort(i) <> &quot;&quot; then for j=0 to DatabaseTableCol.Count Set DatabaseTable = DatabaseTableCol.Item(j) for k=1 to DatabaseTable.Fields.Count...

I have this code currently.. Set DatabaseField = session (&quot;oRpt&quot;).Database.Tables.Item(1).Fields.Item (1) session (&quot;oRpt&quot;).RecordSortFields.Add DatabaseField, 1 But the value I`m going to have to be able to sort by is the field name, not its ordinal. Is there a way to...