Search results for query: *

Don't worry I have found the answer..I was able to just use a custom property of the actual flat file source in the data flow! CustomProperties: FileNameColumnName This captures the full path and name of the file being processed so did just the job! Mark

Hi, I importing multiple txt files in SSIS using a Multiflatfile connection with wildcard. Everything works fine as the number of files could vary at run time as files are each from a different source systems. Now what i need to do is each time a file is processed, read the filename so I can...

Hello, I am trying to make a HTML Item set a parameter value directly (saving user input) and then run the report again. Using what I have the report refreshes but the parameter value does not change. Im Using.. <input type="BUTTON" class="clsPromptButton" onClick=promptButtonFinish()...

cool, thanks]

Hey, Using SQL 2008 I have created a copy of a table but with a different set of indexes on and then inserted all data from the original into the copy. Doing a right click on the tables and selecting Propeties, Storage shows that both tables have the same number of rows (a touch over 20...

many thanks for your replies..Appreciated MadSween

Hey SQL Guru's My new approach to working out NETSALES uses a VAT table rather than CASE statements and is based on a BETWEEN operator with an INNER JOIN to match transaction dates to the correct VATRATE. It will be the first time I have used a BETWEEN operator with an INNER JOIN so I wanted...

Hello All, I am trying to populate variables in a new SSIS package using the Execute SQL Task but I am having an issue to get the actual values to update! Steps I have completed.... Created Variables with Package wide scope Added an Execute SQL task. Pointed connection to Server Edited (&...

How about creating shortcuts in additional locations that all point to the "master" template? That way the document can be accessed from whatever location you want but only a single version really exists?

I guess I am assuming that the pages you want to print are next to each other. If so.. Could you drop the loop and just increase the number of pages being printed so the print goes from pages 1 to i (iVBreaks) i = iVBreaks '''For j = 0 To i On Error Resume Next PDFFileName =...

Sounds like you need to loop and set the connection properties each time using a Dynamic Properties Task. I found www.sqldts.com had some great examples when I was learning how to do this.. Check out Looping, Importing and Archiving http://www.sqldts.com/246.aspx You can download sample pkg at...

Have not seen this before so not sure if this will point you in the right direction? http://support.microsoft.com/kb/281517

Try setting the Global Variable gbMonth back to 2007 and then manually executing each step from the start and then re checking the Global Variable in package properties after each step. This should help you find where the GV is being set blank. Assuming steps run in the order shown I think it’s...

The workaround I had used was as George suggested and gets the jobs done fine. This is part of a large select qry so for neatness I was just hoping I might be able to replace lots of occurances of DateAdd(hh, CASE WHEN START_DATE = SESS_END_DATE THEN 0 ELSE 12 END, START_DATE) with...

Hi, Not critical as I have a work around so this is just to help me learn/improve my code... I would like to know if you can you set a variable when using CASE? I tried various ways but with no luck..I needed to add either 0 or 12 hours to a date based on whether the StartDate and EndDate...

Instead of using.. Dim strFileName as String just use Dim strFileName and you should be OK. In VBScript, all variables are of type variant. Still catches me out! Regards Mark

Hi, try adding this to the end of your code Private Sub WaitRoutine(NoSeconds) Dim PauseTime As Long Dim Start As Long Dim Finish As Long PauseTime = NoSeconds ' Set duration. Start = Timer ' Set start time. Do While Timer < Start + PauseTime DoEvents ' Yield to...

If you are just trying to find which db a table lives in then you should be able use Object search.. In Query Analyzer, Press F4, enter criteria and do 'Find Now'

do you have Mcafee anti virus installed?? Although not directly related to MS Word these may help... http://support.microsoft.com/kb/300028 http://ts.mcafeehelp.com/faq3.asp?docid=68573

Hi, This should do it.... =B1&" "& TEXT(B24,"#.##%") Regards