Stubborn column data type in SSIS flat flat file connection manager won't change. :( Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Data science time! April 2019 and salary with experience Should we burninate the [wrap] tag? The Ask Question Wizard is Live!Data Type Cast Won't Stick in SSISSSIS Excel Import Forcing Incorrect Column TypeSSIS - Can I get the column schema for a flat file source from a database?SSIS - Export image datatype column to a flat fileHow to fix the embedded text qualifier issue while exporting data to CSV flat file?How to reconfigure the column information on a flat file connection manager?SSIS Flat File connection managerSSIS Flat File Source Row RestructureSSIS Package Stubborn Flat File Connection ManagerSSIS issue trying to change Flat File Source Error Output Columnssis add columns to flat file
Does surprise arrest existing movement?
Proof involving the spectral radius and the Jordan canonical form
What happens to sewage if there is no river near by?
What are the motives behind Cersei's orders given to Bronn?
Why aren't air breathing engines used as small first stages
Determinant is linear as a function of each of the rows of the matrix.
How to do this path/lattice with tikz
Why constant symbols in a language?
Dominant seventh chord in the major scale contains diminished triad of the seventh?
How discoverable are IPv6 addresses and AAAA names by potential attackers?
Why was the term "discrete" used in discrete logarithm?
How widely used is the term Treppenwitz? Is it something that most Germans know?
The logistics of corpse disposal
Using et al. for a last / senior author rather than for a first author
How much radiation do nuclear physics experiments expose researchers to nowadays?
Gastric acid as a weapon
When to stop saving and start investing?
How does a Death Domain cleric's Touch of Death feature work with Touch-range spells delivered by familiars?
What do you call a plan that's an alternative plan in case your initial plan fails?
How to deal with a team lead who never gives me credit?
Why is "Consequences inflicted." not a sentence?
What does the "x" in "x86" represent?
Single word antonym of "flightless"
Is above average number of years spent on PhD considered a red flag in future academia or industry positions?
Stubborn column data type in SSIS flat flat file connection manager won't change. :(
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Data science time! April 2019 and salary with experience
Should we burninate the [wrap] tag?
The Ask Question Wizard is Live!Data Type Cast Won't Stick in SSISSSIS Excel Import Forcing Incorrect Column TypeSSIS - Can I get the column schema for a flat file source from a database?SSIS - Export image datatype column to a flat fileHow to fix the embedded text qualifier issue while exporting data to CSV flat file?How to reconfigure the column information on a flat file connection manager?SSIS Flat File connection managerSSIS Flat File Source Row RestructureSSIS Package Stubborn Flat File Connection ManagerSSIS issue trying to change Flat File Source Error Output Columnssis add columns to flat file
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have inherited an existing SSIS package that imports flat file data into my SQL Server 2005 database. I need to change the data type of the "Gross Sales" column from "numeric" to "currency". When I change the data type and export the package the data type remains numeric.
I have also tried creating a new flat file connection to use in the same package, but for some strange reason it still remains numeric instead of "cy" currency. I guess there is something "stuck" in some other area that is forcing the last column to remain numeric?
Does anyone know the trick to changing the data type for a flat file data source?
sql-server sql-server-2005 ssis ssis-data-types edited Nov 24 '12 at 15:36
Lijo
11k55200340
asked Aug 5 '12 at 3:39
programmerprogrammer
72811127
add a comment |
I have inherited an existing SSIS package that imports flat file data into my SQL Server 2005 database. I need to change the data type of the "Gross Sales" column from "numeric" to "currency". When I change the data type and export the package the data type remains numeric.
I have also tried creating a new flat file connection to use in the same package, but for some strange reason it still remains numeric instead of "cy" currency. I guess there is something "stuck" in some other area that is forcing the last column to remain numeric?
Does anyone know the trick to changing the data type for a flat file data source?
sql-server sql-server-2005 ssis ssis-data-types edited Nov 24 '12 at 15:36
Lijo
11k55200340
asked Aug 5 '12 at 3:39
programmerprogrammer
72811127
What is the column type of the destination? My reason behind that question is why worry about changing the data type of source, your focus would be what data type it is when it reaches the destination.
– Shawn Melton
Aug 5 '12 at 4:32
The data type of the destination was decimal(9,2), but I changed it to "money" to allow for some new data that is larger (someone entered 6 billion in sales and then voided it, yay!). I made a simple little test package to reproduce the error and found that the SSIS package is aborting due to it's expectation on the flat file data.
– programmer
Aug 5 '12 at 4:39
Been a while since I worked with flat files, have you tried just doing a data flow transformation to convert it to currency.
– Shawn Melton
Aug 5 '12 at 4:58
2
You created a new flat file connection manager and switched it in the Flat File Source, yes? Right click on the line coming out of that source and select "view metadata" (I think) Does it show the type as Currency there or does it remain numeric?
– billinkc
Aug 6 '12 at 2:50
@billinkc, thanks for the tip! I didn't realize I could view the metadata like that, I just started working with SSIS.
– programmer
Aug 6 '12 at 16:01
add a comment |
I have inherited an existing SSIS package that imports flat file data into my SQL Server 2005 database. I need to change the data type of the "Gross Sales" column from "numeric" to "currency". When I change the data type and export the package the data type remains numeric.
I have also tried creating a new flat file connection to use in the same package, but for some strange reason it still remains numeric instead of "cy" currency. I guess there is something "stuck" in some other area that is forcing the last column to remain numeric?
Does anyone know the trick to changing the data type for a flat file data source?
sql-server sql-server-2005 ssis ssis-data-types edited Nov 24 '12 at 15:36
Lijo
11k55200340
asked Aug 5 '12 at 3:39
programmerprogrammer
72811127
I have inherited an existing SSIS package that imports flat file data into my SQL Server 2005 database. I need to change the data type of the "Gross Sales" column from "numeric" to "currency". When I change the data type and export the package the data type remains numeric.
I have also tried creating a new flat file connection to use in the same package, but for some strange reason it still remains numeric instead of "cy" currency. I guess there is something "stuck" in some other area that is forcing the last column to remain numeric?
Does anyone know the trick to changing the data type for a flat file data source?
sql-server sql-server-2005 ssis ssis-data-types sql-server sql-server-2005 ssis ssis-data-types edited Nov 24 '12 at 15:36
Lijo
11k55200340
asked Aug 5 '12 at 3:39
programmerprogrammer
72811127
edited Nov 24 '12 at 15:36
Lijo
11k55200340
asked Aug 5 '12 at 3:39
programmerprogrammer
72811127
edited Nov 24 '12 at 15:36
Lijo
11k55200340
edited Nov 24 '12 at 15:36
Lijo
11k55200340
edited Nov 24 '12 at 15:36
Lijo
11k55200340
11k55200340
asked Aug 5 '12 at 3:39
programmerprogrammer
72811127
asked Aug 5 '12 at 3:39
programmerprogrammer
72811127
asked Aug 5 '12 at 3:39
programmerprogrammer
72811127
72811127
What is the column type of the destination? My reason behind that question is why worry about changing the data type of source, your focus would be what data type it is when it reaches the destination.
– Shawn Melton
Aug 5 '12 at 4:32
The data type of the destination was decimal(9,2), but I changed it to "money" to allow for some new data that is larger (someone entered 6 billion in sales and then voided it, yay!). I made a simple little test package to reproduce the error and found that the SSIS package is aborting due to it's expectation on the flat file data.
– programmer
Aug 5 '12 at 4:39
Been a while since I worked with flat files, have you tried just doing a data flow transformation to convert it to currency.
– Shawn Melton
Aug 5 '12 at 4:58
2
You created a new flat file connection manager and switched it in the Flat File Source, yes? Right click on the line coming out of that source and select "view metadata" (I think) Does it show the type as Currency there or does it remain numeric?
– billinkc
Aug 6 '12 at 2:50
@billinkc, thanks for the tip! I didn't realize I could view the metadata like that, I just started working with SSIS.
– programmer
Aug 6 '12 at 16:01
add a comment |
What is the column type of the destination? My reason behind that question is why worry about changing the data type of source, your focus would be what data type it is when it reaches the destination.
– Shawn Melton
Aug 5 '12 at 4:32
The data type of the destination was decimal(9,2), but I changed it to "money" to allow for some new data that is larger (someone entered 6 billion in sales and then voided it, yay!). I made a simple little test package to reproduce the error and found that the SSIS package is aborting due to it's expectation on the flat file data.
– programmer
Aug 5 '12 at 4:39
Been a while since I worked with flat files, have you tried just doing a data flow transformation to convert it to currency.
– Shawn Melton
Aug 5 '12 at 4:58
2
You created a new flat file connection manager and switched it in the Flat File Source, yes? Right click on the line coming out of that source and select "view metadata" (I think) Does it show the type as Currency there or does it remain numeric?
– billinkc
Aug 6 '12 at 2:50
@billinkc, thanks for the tip! I didn't realize I could view the metadata like that, I just started working with SSIS.
– programmer
Aug 6 '12 at 16:01
What is the column type of the destination? My reason behind that question is why worry about changing the data type of source, your focus would be what data type it is when it reaches the destination.
– Shawn Melton
Aug 5 '12 at 4:32
What is the column type of the destination? My reason behind that question is why worry about changing the data type of source, your focus would be what data type it is when it reaches the destination.
– Shawn Melton
Aug 5 '12 at 4:32
The data type of the destination was decimal(9,2), but I changed it to "money" to allow for some new data that is larger (someone entered 6 billion in sales and then voided it, yay!). I made a simple little test package to reproduce the error and found that the SSIS package is aborting due to it's expectation on the flat file data.
– programmer
Aug 5 '12 at 4:39
The data type of the destination was decimal(9,2), but I changed it to "money" to allow for some new data that is larger (someone entered 6 billion in sales and then voided it, yay!). I made a simple little test package to reproduce the error and found that the SSIS package is aborting due to it's expectation on the flat file data.
– programmer
Aug 5 '12 at 4:39
Been a while since I worked with flat files, have you tried just doing a data flow transformation to convert it to currency.
– Shawn Melton
Aug 5 '12 at 4:58
Been a while since I worked with flat files, have you tried just doing a data flow transformation to convert it to currency.
– Shawn Melton
Aug 5 '12 at 4:58
2
2
You created a new flat file connection manager and switched it in the Flat File Source, yes? Right click on the line coming out of that source and select "view metadata" (I think) Does it show the type as Currency there or does it remain numeric?
– billinkc
Aug 6 '12 at 2:50
You created a new flat file connection manager and switched it in the Flat File Source, yes? Right click on the line coming out of that source and select "view metadata" (I think) Does it show the type as Currency there or does it remain numeric?
– billinkc
Aug 6 '12 at 2:50
@billinkc, thanks for the tip! I didn't realize I could view the metadata like that, I just started working with SSIS.
– programmer
Aug 6 '12 at 16:01
@billinkc, thanks for the tip! I didn't realize I could view the metadata like that, I just started working with SSIS.
– programmer
Aug 6 '12 at 16:01
add a comment |
4 Answers
4
active
oldest
votes
Thanks for all the help everyone. It looks like in my case I needed to delete and re-add the flat file source step and add a new flat file connection manager. Maybe there was a better way to do it and I was just clicking in the wrong order in the GUI maze in SSIS. :D
answered Aug 6 '12 at 16:06
programmerprogrammer
72811127
add a comment |
Did you try adding a Data Conversion Transformation Task in your DT?.
e.g. You can modify the Gross Sales as
Gross Sales, Gross Sales_CONV Choose Currency [DT_CY] as your currency.
answered Aug 6 '12 at 10:09
WaZWaZ
1,07731626
Obviously the above can only be applied to a DT. Not sure why the data type doesn't change during import.
– WaZ
Aug 6 '12 at 10:14
add a comment |
I've also found that sometimes changing ValidateExternalMetaData to false on the Source and Destination properties will help.
answered May 28 '15 at 15:22
MelanieMelanie
2,01852845
add a comment |
When some changes don't apply, even though there's no apparent reason for the data to be "stubborn" and resist change, you should try closing Visual Studio and open it back again.
In my case it works for this mentioned failure, as well as when the Script Editor won't open. It looks like some information remains on cache and prevents some functionalities from working properly.
In my case I had a lot of columns in my flat file connection manager, so deleting the connection and adding those columns back again one by one was the last thing I would try.
edited Mar 8 at 16:57
Pikachu the Purple Wizard
2,11661529
answered Mar 8 at 16:35
Javier D.Javier D.
3518
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f11813768%2fstubborn-column-data-type-in-ssis-flat-flat-file-connection-manager-wont-change%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for all the help everyone. It looks like in my case I needed to delete and re-add the flat file source step and add a new flat file connection manager. Maybe there was a better way to do it and I was just clicking in the wrong order in the GUI maze in SSIS. :D
answered Aug 6 '12 at 16:06
programmerprogrammer
72811127
add a comment |
Thanks for all the help everyone. It looks like in my case I needed to delete and re-add the flat file source step and add a new flat file connection manager. Maybe there was a better way to do it and I was just clicking in the wrong order in the GUI maze in SSIS. :D
answered Aug 6 '12 at 16:06
programmerprogrammer
72811127
add a comment |
Thanks for all the help everyone. It looks like in my case I needed to delete and re-add the flat file source step and add a new flat file connection manager. Maybe there was a better way to do it and I was just clicking in the wrong order in the GUI maze in SSIS. :D
answered Aug 6 '12 at 16:06
programmerprogrammer
72811127
Thanks for all the help everyone. It looks like in my case I needed to delete and re-add the flat file source step and add a new flat file connection manager. Maybe there was a better way to do it and I was just clicking in the wrong order in the GUI maze in SSIS. :D
answered Aug 6 '12 at 16:06
programmerprogrammer
72811127
answered Aug 6 '12 at 16:06
programmerprogrammer
72811127
answered Aug 6 '12 at 16:06
programmerprogrammer
72811127
answered Aug 6 '12 at 16:06
programmerprogrammer
72811127
72811127
add a comment |
add a comment |
Did you try adding a Data Conversion Transformation Task in your DT?.
e.g. You can modify the Gross Sales as
Gross Sales, Gross Sales_CONV Choose Currency [DT_CY] as your currency.
answered Aug 6 '12 at 10:09
WaZWaZ
1,07731626
Obviously the above can only be applied to a DT. Not sure why the data type doesn't change during import.
– WaZ
Aug 6 '12 at 10:14
add a comment |
Did you try adding a Data Conversion Transformation Task in your DT?.
e.g. You can modify the Gross Sales as
Gross Sales, Gross Sales_CONV Choose Currency [DT_CY] as your currency.
answered Aug 6 '12 at 10:09
WaZWaZ
1,07731626
Obviously the above can only be applied to a DT. Not sure why the data type doesn't change during import.
– WaZ
Aug 6 '12 at 10:14
add a comment |
Did you try adding a Data Conversion Transformation Task in your DT?.
e.g. You can modify the Gross Sales as
Gross Sales, Gross Sales_CONV Choose Currency [DT_CY] as your currency.
answered Aug 6 '12 at 10:09
WaZWaZ
1,07731626
Did you try adding a Data Conversion Transformation Task in your DT?.
e.g. You can modify the Gross Sales as
Gross Sales, Gross Sales_CONV Choose Currency [DT_CY] as your currency.
answered Aug 6 '12 at 10:09
WaZWaZ
1,07731626
answered Aug 6 '12 at 10:09
WaZWaZ
1,07731626
answered Aug 6 '12 at 10:09
WaZWaZ
1,07731626
answered Aug 6 '12 at 10:09
WaZWaZ
1,07731626
1,07731626
Obviously the above can only be applied to a DT. Not sure why the data type doesn't change during import.
– WaZ
Aug 6 '12 at 10:14
add a comment |
Obviously the above can only be applied to a DT. Not sure why the data type doesn't change during import.
– WaZ
Aug 6 '12 at 10:14
Obviously the above can only be applied to a DT. Not sure why the data type doesn't change during import.
– WaZ
Aug 6 '12 at 10:14
Obviously the above can only be applied to a DT. Not sure why the data type doesn't change during import.
– WaZ
Aug 6 '12 at 10:14
add a comment |
I've also found that sometimes changing ValidateExternalMetaData to false on the Source and Destination properties will help.
answered May 28 '15 at 15:22
MelanieMelanie
2,01852845
add a comment |
I've also found that sometimes changing ValidateExternalMetaData to false on the Source and Destination properties will help.
answered May 28 '15 at 15:22
MelanieMelanie
2,01852845
add a comment |
I've also found that sometimes changing ValidateExternalMetaData to false on the Source and Destination properties will help.
answered May 28 '15 at 15:22
MelanieMelanie
2,01852845
I've also found that sometimes changing ValidateExternalMetaData to false on the Source and Destination properties will help.
answered May 28 '15 at 15:22
MelanieMelanie
2,01852845
answered May 28 '15 at 15:22
MelanieMelanie
2,01852845
answered May 28 '15 at 15:22
MelanieMelanie
2,01852845
answered May 28 '15 at 15:22
MelanieMelanie
2,01852845
2,01852845
add a comment |
add a comment |
When some changes don't apply, even though there's no apparent reason for the data to be "stubborn" and resist change, you should try closing Visual Studio and open it back again.
In my case it works for this mentioned failure, as well as when the Script Editor won't open. It looks like some information remains on cache and prevents some functionalities from working properly.
In my case I had a lot of columns in my flat file connection manager, so deleting the connection and adding those columns back again one by one was the last thing I would try.
edited Mar 8 at 16:57
Pikachu the Purple Wizard
2,11661529
answered Mar 8 at 16:35
Javier D.Javier D.
3518
add a comment |
When some changes don't apply, even though there's no apparent reason for the data to be "stubborn" and resist change, you should try closing Visual Studio and open it back again.
In my case it works for this mentioned failure, as well as when the Script Editor won't open. It looks like some information remains on cache and prevents some functionalities from working properly.
In my case I had a lot of columns in my flat file connection manager, so deleting the connection and adding those columns back again one by one was the last thing I would try.
edited Mar 8 at 16:57
Pikachu the Purple Wizard
2,11661529
answered Mar 8 at 16:35
Javier D.Javier D.
3518
add a comment |
When some changes don't apply, even though there's no apparent reason for the data to be "stubborn" and resist change, you should try closing Visual Studio and open it back again.
In my case it works for this mentioned failure, as well as when the Script Editor won't open. It looks like some information remains on cache and prevents some functionalities from working properly.
In my case I had a lot of columns in my flat file connection manager, so deleting the connection and adding those columns back again one by one was the last thing I would try.
edited Mar 8 at 16:57
Pikachu the Purple Wizard
2,11661529
answered Mar 8 at 16:35
Javier D.Javier D.
3518
When some changes don't apply, even though there's no apparent reason for the data to be "stubborn" and resist change, you should try closing Visual Studio and open it back again.
In my case it works for this mentioned failure, as well as when the Script Editor won't open. It looks like some information remains on cache and prevents some functionalities from working properly.
In my case I had a lot of columns in my flat file connection manager, so deleting the connection and adding those columns back again one by one was the last thing I would try.
edited Mar 8 at 16:57
Pikachu the Purple Wizard
2,11661529
answered Mar 8 at 16:35
Javier D.Javier D.
3518
edited Mar 8 at 16:57
Pikachu the Purple Wizard
2,11661529
edited Mar 8 at 16:57
Pikachu the Purple Wizard
2,11661529
edited Mar 8 at 16:57
Pikachu the Purple Wizard
2,11661529
2,11661529
answered Mar 8 at 16:35
Javier D.Javier D.
3518
answered Mar 8 at 16:35
Javier D.Javier D.
3518
answered Mar 8 at 16:35
Javier D.Javier D.
3518
3518
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f11813768%2fstubborn-column-data-type-in-ssis-flat-flat-file-connection-manager-wont-change%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What is the column type of the destination? My reason behind that question is why worry about changing the data type of source, your focus would be what data type it is when it reaches the destination.
– Shawn Melton
Aug 5 '12 at 4:32
The data type of the destination was decimal(9,2), but I changed it to "money" to allow for some new data that is larger (someone entered 6 billion in sales and then voided it, yay!). I made a simple little test package to reproduce the error and found that the SSIS package is aborting due to it's expectation on the flat file data.
– programmer
Aug 5 '12 at 4:39
Been a while since I worked with flat files, have you tried just doing a data flow transformation to convert it to currency.
– Shawn Melton
Aug 5 '12 at 4:58
2
You created a new flat file connection manager and switched it in the Flat File Source, yes? Right click on the line coming out of that source and select "view metadata" (I think) Does it show the type as Currency there or does it remain numeric?
– billinkc
Aug 6 '12 at 2:50
@billinkc, thanks for the tip! I didn't realize I could view the metadata like that, I just started working with SSIS.
– programmer
Aug 6 '12 at 16:01