Search results for query: *

Create a ForEach Loop Container. Set your "collection" property to xxxxx_.* Then put all your processing within this container. It will pick up each file matching the collection pattern and put it through the tasks.

If you are able to modify your dataset query and it is acceptable to have a space where this CrLf is in your data, you might also try something like: REPLACE(yourColumnName, CHAR(13)+CHAR(10), ' ') This will put all your text into one "line" by replacing a CrLf pair with a single space. You...

Don't know if this will help or even if it answers the question, but here is what I do when I want to clone a report in a project. From VS, in the Solution Explorer, right-click "Reports" and choose Add -> Existing Item... In the dialog that is displayed, scroll to the original report RDL...

Not sure this will help, but give it a try. This assumes that column 4 in the flat file will only have one character. Right-click and edit your source file in the Connection Managers. Select the "Advanced" topic in the left pane. In the middle pane, select column 4. In the right pane...

Steve: If you simply want to show "This Month", etc in the dropdown, you can add a parameter and just load in those values. The stored procedure could then receive that as a parameter and make the date range calculations based on the text. Another option may be to add a dataset and populate...

This is pretty crude and not sure your data will lend itself to this technique, but maybe it will spark something to get you to your answer. I'll create a temp table (table var in this case) and load in the first few months of your data, in reverse order to illustrate your data does not need to...

To just get rid of the decimal, you could use REPLACE: REPLACE(CONCAT((CAST(id AS VARCHAR(15))), (CONCAT((CAST(package_size AS VARCHAR(15))),(package_unit)))), '.', '')

I'm thinking I would leave the "and comm.type = 'xxx'" out of the JOIN. Even if you have userID's duplicated between SER and EMP, your CASE is going to get the name from the correct table.

You should be able to right-click the textbox that contains your column data reference, select "Text Box Properties...", in the dialog select "Number" in the left pane, then select "Time" in the right pane under "Category:", then select "13:30:00" in the "Type:" section. This should establish...

I should have mentioned that SEQUENCE is only available on SQL Server 2012 and up. So you won't be able to use this on earlier versions. If that is the case, I don't know how to do this on an INSERT but it can be done in an UPDATE. If you were to insert these rows first with some unique tag...

Check out the CREATE SEQUENCE syntax. That might do what you want, but it won't work with TOP so you'll have to work around that. But some fiddling might yield the desired results.

Does this do what you want? INSERT INTO ExistingTable (KeyCol, FirstCol, SecondCol, ThirdCol) SELECT TOP 500 '12345' ,'Testing' ,'Testing' ,'Testing' FROM sys.all_objects

These options are not currently available in any version of SSRS Report Manager so far. Sorry. I have seen requests for this on Connect but no feedback from Microsoft yet.

The Report Manager has a "Download" option which will let you drop the RDL into a folder somewhere, and then use "Add Item" to get it into your project. -Jim-

Not sure I fully understand your requirement, but here is a quick shot at what I think you are asking. SELECT TOP 500 '12345' AS Column1 ,'Testing' AS Column2 ,'Testing' AS Column3 ,'Testing' AS Column4 FROM sys.all_objects This gives me 500 rows of 12345, Testing, Testing, Testing -Jim-

I've only found two ways: 1) Format a column with the desired characteristics, then append columns from the dataset. The appended column will inherit some (not all) of the attributes of the column to the left. 2) Press F7 and VERY carefully edit the RDL code with copy/paste. You're right...

Re SQL Server 2008 R2 SSIS When we use the sp_send_dbmail procedure in a T-SQL query, the email activity is logged in a system database table. However, I cannot find a similar logging capability with SSIS when using the Send Mail Task. I have the feeling that the feature does not exist, but...

The first thought that comes to mind is perhaps the server hosting Report Manager is a beefier machine than your workstation, and maybe does not have competing applications opened at the same time as one might have on their desk. Also, is the Report Manager server the same machine supporting...

-SQLBill: Forest for the trees. Been there.

You need to say WHERE route < 100 OR (route BETWEEN 200 AND 499) You need the OR instead of AND to get routes less than 100 (0-99). Also, I tested BETWEEN with INT values and it picked up 200 and 499, unlike what SQLBill has suggested. If BETWEEN was not inclusive of the start/end values, I...