Container Content Edit Wierdness

Apr 11, 2007

I attempted to move some tasks into a new sequence container. It failed saying element cannot be found in a collection. Now I find that visually the tasks do not appear in the container. But in some ways they are. I can not try to move the tasks to the container, or I get the same "element can not be found". If I execute the container, the tasks outside the container run.

I thought to CUT and PASTE my tasks, but then it says "The package contains one or more event handlers for this task. Deleting the task will also delete the event handlers and the event handler context."

View 4 Replies


ADVERTISEMENT

Sysaltfiles Wierdness

May 31, 2007

Hi,

We tried to create a new database on an application server (Win 2003 server/SQL Server 2003) and got the following error.


error 945....

....
device activation error. The physical filename g:m
ssqldata emplog.ldf may be incorrect.

The interesting thing is that tempdb is on f:mssql as shown in the database properties and with sp_dbhelp.

Poking around in master the real wierdness comes through. sysaltfiles has 2 entries each for tempdb logs and data files. One of them is on g: and one is on f:. The lower dbid is on f: and the higher one is on g: (actually the last two rows in the table).

Several months ago our software vendor moved tempdb from g: to f: to try and speed it up a bit. Appearantly they messed it up and now have written us off till WE fix it.

The entries in sysaltfiles were the only references to g: that turned up (though we didn't look at every table and aren't even remotely sure where other references might be located).

Any pointers on getting this corrected would be greatly apprecieated. We thought about trying a reconfigure and restarting but I'm not real hopeful. We also thought about just updating the wrong entries to reflect the right locations but that smacks of kluge.

Tangential wierdness is that while trying to isolate the source of g:mssql in the error I found that in master.sysdevices the file location is e:Program FilesMicrosoft SQL ServerMSSQLdata empdb.mdf.

I believe this is from the initial install then while configuring the server it got moved to g: then to f:.

HELP!!!

Thanks in advance for any input!
Rusty

View 3 Replies View Related

Merged Record Order Wierdness

Sep 14, 2007

I'm using the Merge transformation to merge two sorted tables on four sort fields.

It all looks OK until several records share some of the same sort fields.

For example if table 1 contains


Zip Code(sort field 1) Cust Name(sf2) Cust Number(sf3) Record type(sf4)
1234 Bob 444 A
1234 Bob 555 A

and table 2 contains

Zip Code Cust Name Cust Number Record type
1234 Bob 444 B
1234 Bob 555 B

then the output order is

Zip Code Cust Name Cust Number Record type
1234 Bob 444 A
1234 Bob 555 A
1234 Bob 444 B
1234 Bob 555 B

and I would have expected

Zip Code Cust Name Cust Number Record type
1234 Bob 444 A
1234 Bob 444 B

1234 Bob 555 A
1234 Bob 555 B

Both input table are explicitly sorted just prior to the merge.

Any ideas?

View 6 Replies View Related

Loop Container Inside A Sequence Container

Jul 25, 2007

Has anyone ever seen this issue?



If i place a loop container inside a sequence container the connectors within the loop container disappear.... is this a bug - will the loop tasks still run in the correct order?? or will they fire off willy nilly??







View 4 Replies View Related

For Each Container With XML

Apr 18, 2008

I have an execute sql task that uses the following query: (modified for this thread but normally its going to return all records in the table)





Code Snippet

SELECT


'PrimaryID' AS 'Parameter/name',
PrimaryID AS 'Parameter/value',
'LastName' AS 'Parameter/name',
LastName AS 'Parameter/value'

FROM ParkingUpload
WHERE primaryid = '1234' or primaryid = '4321'

FOR XML PATH('T2Method')

The output of this query looks like this: (I know normally this would be a bad xml file, but its needed for my purpose)





Code Snippet

<T2Method>
<Parameter>
<name>PrimaryID</name>
<value>1234</value>
<name>LastName</name>
<value>Abiola</value>
</Parameter>
</T2Method>
<T2Method>
<Parameter>
<name>PrimaryID</name>
<value>4321</value>
<name>LastName</name>
<value>Aboud</value>
</Parameter>
</T2Method>
That xml is stored in a user variable in the Execute SQL Task. I need to take that user variable and send out that xml to a webservice. The web service is expecting one record at a time(a new record is defined by the <T2Method> node.

So question is, does my approach seem fine so far? I was wondering if my next step should be to put this variable in a For Each Container and send out one record at a time to the webservice. If so, how would I go about doing that?

If anyone else has a different suggestion as how to approach this, or be able to help with the For Each portion (I am brand new to SSIS), I would really appreciate it.

View 5 Replies View Related

Sequence Container

Apr 26, 2006

i am trying to insert data into a table and roll back if this fails. What i have done is created an Execute SQL task with a SQL statement of BEGIN TRANS .. if the constraint = success then it goes to a Sequence Conatiner that amoungst other thing includes an Execute SQl task that does INSERT statement . outsied of the container i have 2 execute sql tasks that to a COMMIT TRANS ond a ROLLBACK Trans . when executing it i get an error the Rollback Transaction request has no corrasponding Begin tranaction. I have seen this in a SSIS created by one of the Wizards and it works fine, im oviously missing something fundemental .. any pointers ?

View 1 Replies View Related

SQL Vs XML Page Content

Apr 2, 2008

I want to create the most effective way (google) to have content displayed on a web page. 
Currently, we are updating to SQL and populating to web via calling SQL statements hardcoded to page.  I want to know if this is ok to do, or should we be reading from a static XML file that is updated? 
 I think the XML is the way to go being that i may have answered my own question, but i was curious to what the experts on asp.net had to say.
Thanks,Nick

View 9 Replies View Related

Moving Content From One Db To Another

Mar 9, 2007

an outside developer has sent us a mdf file that contains the need updates to a database.

here is where the problem comes in, how can i append the contents of the mdf file to an existing db?

there are about a dozen tables, 50 stored procs, and one new user.

View 2 Replies View Related

Foreach Loop Container

Jan 22, 2008

Hello Experts,

Sorry that I open a new thread again but I didn€™t found any good tutorials about foreach loop container. I would like to read every row from one table and do something.
I red something about sql task€¦ Can someone give a little instruction, please?

Kind regards,
Alex

View 3 Replies View Related

Roll Back In For Each Container

Jul 31, 2007



Hi,
I'm using data flow as flat file source -> derived column ->Data Conversion-> oledb destination
I have a fifty thousand record in a delimited file. while processing i got error in 45000th row. In database only 40000 records are there(why is there no all 45000 records). Is there any way to roll back all the 40000 records.

View 9 Replies View Related

Using Foreach Loop Container

Feb 15, 2007

Hi



I using data flow task to import from flat file to database but i need to use Foreach Loop Container to import multiple files in specific folder and all will be insert in the same table



tahnks & Regards



View 1 Replies View Related

Sequence Container And Checkpoints

Mar 6, 2008



hi people, i have crashed on a this problem. I have a sequence container and on this container I have set "FailPackageOnFailure=true". Now in this container there are 2 tasks. The first one is preceeding the second one. Now both this task have set "FailParentOnFailure=true". Both task are the same and their purpose is to drop table A.

1) I run the package and it fails, because there is no table to drop.
2) I create the table manualy and run package again.
3) I see, that the first task is beeing just SIMPLE OMMITED and the second task runs

In general, everytime any task in a sequence container invokes failure, next time is beeing ommited regardelss of its status. How can this be fixed ? Thanks

View 4 Replies View Related

AssignExpression In For Loop Container

Feb 27, 2006

What I'm trying to do is take multiple "snapshots" of a membership for many months. I was trying to do this in a For Loop Container in which I added one to the month variable and subtracted one from an iteration variable each loop, unless the month variable = 13...then I would add one to the year variable, set the month variable to 1 and subtract one from the iteration variable. This, I was hoping, would allow me to initialize 24 to the iteration variable, 1 to the month variable and 2004 to the year variable, kick off the package, and get 2 years worth of "snapshots" in seperate files (one for each month). Here is the AssignExpression I thought would work:

@Member_Month == 13 ? @Member_Month = 1 && @Member_Year= @Member_Year + 1 && @Member_Iteration = @Member_Iteration - 1 : @Member_Month = @Member_Month + 1 && @Member_Iteration = @Member_Iteration - 1

The package states that the single "=" should be double, but I don't think that that is what I want to do (I tried doing this just to check, and it didn't like this either). I think that it is having problems with doing multiple things on both sides of the ":". What am I doing wrong?



Thanks,

Brian Layden

View 1 Replies View Related

RAID 10 Container And How To Carve It Up

Oct 19, 2007

Afternoon Folk ...

Here is the question.

I have a RAID 10 container consisting of 4 146GB, SAS, 3.5-inch 15K RPM Hard Drives.


We have the OS on its own RAID so we are strictly dealing with setting up SQL Server 2005 on the RAID 10.

SO ... is it better to create seperate volumes for the Data, TLog and TempDB file placements (i,e, C:, F: and G or is it alright to create just plain-jane folders for the file placements?

Does it make a difference?

Is there a better way to carve this RAID 10 up?

Thanks ALL!

View 7 Replies View Related

Extending SSIS Container?

Jul 24, 2006



Has anyone investigated extending any of the SSIS Container classes?

I have been looking into it because we'd like to add a set of standard logging calls on events, standard startup procedures, etc. on any package that we execute.

I've been looking into the Sequence Container, For-Each, etc. They are all sealed classes. I'm not sure why MS has sealed them.

We're currently thinking of implementing our own version of the Sequence Container -- we'd really like to be able to extend the functionality of a standard container class, but we don't want to have to implement the actual container class itself.

Any insight appreciated.

View 5 Replies View Related

Variables And ForEach Container

Aug 22, 2006

Is there a way to set a variable as a substring of the enumerator in a Foreach File Enumerator type? The Variable Mappings tab in the Foreach Loop Editor does not allow you to enter an expression.

Fred

View 13 Replies View Related

Grouping Container, Is There Any Limitation?

Oct 24, 2006

hi guys,

I was wondering about a silly thing but, anyway, which is the maximum number of grouping for a container? I mean, when you group from, i.e, a sql task and then over that group do again another one and so on...

Thanks in advance for your time,

View 3 Replies View Related

Probelm Using For Each Loop Container

May 18, 2007


We have a config table which has columns like pollingfolder, cop to folder etc.
Data looks like this
Config id polling folder
1 d:dataloadacn
2 d:dataloadship
under ACN and Ship folders we can have more than 1 source files which had to be loaded into target
the load process has to be repeated for each file in all the folders like ACN and ship
I have used for each loop container to poll the folder.
Can we set the directory to be polled at runtime taking from config table.
For doing this I have used the property Directory in expression editor of for each loop. But it is not working.
If I hard code the variable value in variables section , then its working.
How to change the directory to be polled value at runtime?

View 1 Replies View Related

For Loop Container With Dates

Apr 25, 2007

I'm trying to set up a For Loop Container that steps through the loop based on date logic.

Here's an example of what I'd like to do:



InitExpression | @SomeDate = 1/1/2007

EvalExpression | @SomeDate < GETDATE()

AssignExpression | @SomeDate = DATEADD(DAY, 1, @SomeDate)



The above syntax does not work, and I can't find an example that uses date logic with the For Loop Container.



Can anyone help me with this, or point me to an example that uses the For Loop Container with dats?



Thanks in advance for the help!

View 9 Replies View Related

For Each Loop Container In SSIS

Mar 12, 2008



Hi,

I am using For each loop container in my SSIS package which will loop through more than one input file in the input folder.
All the input files in the input folder are picked by one by one. All the input files in the input folder are executed with the same ExecutionInstanceGUID.

Now, my requirement is to get a new ExecutionInstanceGUID during the execution of each input file in the For each loop container. My package only contains the For each loop container with some logic inside that.

Please let me know if any one can help me for the same.

Regards,
Sriram.

View 6 Replies View Related

ForEachLoop Container And Variables

Apr 20, 2007

Hi Guys



I am trying to do the following and am quite new to SSIS.



I have to select a dataset from a database on server A, check if it exists on server B and perform an Update or Insert dependant on the existence.



I have created a SQL task to do the Select from server A with the results set passed to a variable of Vendors. I have added a ForEach Loop container with an enumerator of Foreach ADO Enumerator and the source variable is set to Vendors.



I have created 2 variables in the Foreach Loop called Code and Supplier - both as strings - as there are 2 fields from the initial Select that need to be passed to the final Update/ Insert.



I have then created another SQL task insert the Foreach which will perform the Update/Insert.



obviously when I run it at the moment it performs the Update/ Insert but just adds the rows with both Code and Supplier as NULL.



having looked at a couple of examples in books I have i know i need to add something in the Expressions of the Update/Insert SQL task but it is here i get a bit lost.



Which of the properties from the drop down do i need to use to map the variables against?



Any help would be massively appreciated asI am tearing my hair out!



Thanks



Scott

View 5 Replies View Related

For Each Loop Container Do Nothing Inside

Aug 27, 2006

Hi,

A very strange thing happened to me. I have a package that includes two For each loop containers. Each container has script tasks, sequence containers, etc. Both are Foreach ADO Enumerator basis. It works without any problems until I changed the position of one of them in the Control flow and added some code in the script task. After these changes I executed the package and both of For each loop containers did not execute the tasks inside of them, any task. However the execution color on the containers was green (success). How can it be?

Your help is much welcome. Thanks in Advance.

JoĂŁo Cruz









View 2 Replies View Related

Using A ForEach Loop Container

Mar 30, 2007

Hi



Can anyone point me to an example of using a ForEach Loop Container to step through the rows in a recordset. I cannot seem to see how this is done from the help files.



Thanks

View 6 Replies View Related

Executing A Whole Container In One Transaction

Oct 15, 2006

Hello all,

I am trying to build a package running a container that includes several tasks: 2 Execute SQL tasks and a data flow task. I would like to execute this container in a single transaction, which means that if any of the tasks fail, no changes are been made by the container execution.
To achieve this, I have followed the instructions of how to configure the DTC on the server and locally, and set the container's TransactionOption Property to "Required".

The problem I encounters is that when using a dataflow task in the container, the running process runs OK until it reaches the dataflow task, then it just gets stuck (marking the task in yellow). When removing the dataflow task, left with only Execute SQL tasks everything works fine.
Any idea?

Thanks,
Liran

View 8 Replies View Related

For Loop Container In SSIS

Aug 13, 2007



WHAT IS THE USE OF THE FOR LOOP CONTINER

PLEASE GIVE ME THE EXAMPLE

REGARDS
KOTI

View 5 Replies View Related

Expressions In For Loop Container

Feb 26, 2007

Hi,
I am having problem when setting for-each container's EvalExpression as a variable comparison.

I have set this in expression editor
@[User::Syn] == 1

Editor says that it couldnt convert from System.Bool to System.String.

If I put it in quote, then for-each container says that it needs Bool, not String.


Please help me with this,
Thanks

View 7 Replies View Related

How To Store A Content Into Database

Aug 22, 2006

Hi everyone,
 
I'm just using TEXTBOX control to save data into my DB. My question is, if I have multiple lines of sentences, it does not store as what it looks like. For example;
 
Hello, Mike
 
It stores into the database as "Hello, Mike" and if I read from the database, it does not have seperate lines and shows it like this;
Hello, Mike
 
How can I store the contents into database and make the contents as original? (Sorry for the poor English, but I hope you understand it.)

View 2 Replies View Related

Automatic Content Expiry

Jun 21, 2007

Hi All,I have a job coming up which involves me creating a  vacancy system for our website.I (think) I'll only need one table:ID (PK)JobTitleJobLocationSalaryHoursJobDescriptionValidFrom (Date/Time)ValidTo (Date/Time)I'll display this data using a C#.Net repeater but I was wondering how I can automatically strip the page of the jobs that have gone past their expiry date? Is is straightforward to achieve?Thanks in advance,Brett 

View 2 Replies View Related

How To Modify Xml Content In SQL 2000

Jan 14, 2008

HiI have developed a sql procedure for updating some xml content using SQL 2005 xQuery features.For example:Declare @xmlContent = '<books><book name="asp"/>< book name = "sql"/></books>'--Now I want to add attribute "book_id" to the xml content.SET @xmlContent.modify('insert attribute book_id{"1" } into (/books/book[@name="asp"])[1] ')SET @xmlContent.modify('insert attribute book_id{"2" } into (/books/book[@name="sql"])[1] ')SELECT @xmlContent--OUTPUT will be<books><book name="asp" book_id="1"/><book name="sql" book_id="2"/></books>QUESTIONQ1. Do we have any extension or plugin such that this SQl 2005 xquery feature can be incorporated in SQL 2000?Q2. If the answer for Q1. is no (as I expect), then do we have any TSQL feature in SQL 2000 for modifying xml content?I found all examples in SQl 2000 related with "openxml" function which performs the select kind of operations only. Like selecting data in XML format OR converting xml data in to tabular format. But I couldn't find any xml modification TSQL in SQl 2000 which can add element/attributes or change values.one workaround could be to consider xml content as string and use string functions to modify the content.But is there any more sensible approach available in SQL 2000?    

View 1 Replies View Related

SQL Server As Content Store

Dec 29, 2003

Okay, moving to developing a small site that will be storing articles - that is a site largely consisting of html marked up articles with images. We already have an SQL Server so it is becoming the back-end.

So, since I'm not an SQL Server expert, some general advice on this would be appreciated? The articles, as I say in HTML (largely just markup for titles, and general text) would be stored in the DB? As Text datatypes?

How about the images...on disk or in SQL?

View 3 Replies View Related

Cannot Able To See The Content Of A Column In A Table?

Nov 12, 2001

hi everybody,

The problem is, I have a table with one column of varchar(8000) datatype. It has got 1000's of records. Through Query Analyzer, I am not able to view my records after 257 columns in my table, even I increased my textsize by using 'set textsize' command.

Any other setting is available to correct this. Any help is appreciated.

thanks,
Vasu

View 2 Replies View Related

Table Empty Of Content

Sep 10, 2001

I have a particular production database that on a few recent occasions has suddenly had one of it's tables empty of content. Now there are no jobs or triggers in place neither is any stored procedures that could perform a delete or alter table operation in place. The permissions have been set not to allow this either. The datatype is text only. What is intriguing is the QA server has an exact mirror and this dosen't happen. Has anyone come across this sort of phenomenon?

View 2 Replies View Related

Field Content Alteration

Feb 24, 2000

Hello,

I have a field in a table called 'CourseId' - the course Id should always contain a backslash somewhere in the list of numbers eg :

12342322
11231131

Unfortunately, some of the course Ids have a forward slash instead of a backslash eg :

462322/1
23/232323

How can I update the field to replace the / with a

Any help is very much appreciated.

Thanks in advance,

Anthony

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved